How to load a particular sheet from different excel??

[soha1902]

Hi All,

I am having 10 excel file in one url. (In future it’ll increase or decrease)

All excel files names are different but all having the same structure (Same sheet names and column names)

All excel files having the 3 sheets like Sheet A, B, and C.

I want to load Sheet B only from all excel files through one LOAD statement.

Can anyone please suggest me how to do this???

For example:

Following are 5 sheets and all are having 3 sheets like Sheet A, B, and C.

I want to load Sheet B only from all excel files through one LOAD statement.

(All are dummy url only)

1. https //sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_First.xlsm"
2. https // sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Second.xlsm"
3. https // sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Third.xlsm"
4. https // sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Fourth.xlsm"
5. https // sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Fifth.xlsm"

Please Help......

[amit_saini]

Hi Soha,

For example I'm having these three sheet as below:

Operations Panel ChartsKautex 2013 ABC.xlsx

Operations Panel ChartsKautex 2013 DEF.xlsx

Operations Panel ChartsKautex 2013 AXZ.xlsx

mention below is the link which will help you to call all the sheets (Condition you should have similar column names inside for all of them)

[http://....../Operations/global/Documents/Reporting/Operations%20Panel%20ChartsKautex%202013%20$(P)....]

In this link I'm calling 'P' as vaiable having values ABX, DEF,AXZ....etc

Thanks,

AS

[amit_saini]

Hi Soha,

See the attachment.

Thanks,

AS

[#4]

It works for me Soha. I had similar situation to load the data from files of different month like Apr.xls, May.xls. You have to copy all the files at the same location and then run a for loop with the filename .

[soha1902]

Hello Amit,

Can you please let me know where we need to assign value in variable 'P'.

In your case you didn't assign any value in variable 'P'.

How it fetch all the data from different excel file???

Thanks for you reply...

[amit_saini]

Soha,

You have to create a vairable in your application and assign value as in my case it should be ABC,DEF,AXZ to read all these three sheet from one link.

Thanks,
AS

[shane_spencer]

If you can provide some sample files I'll try to build a load script for you.