How to load a sheet from multiple excel files??

soha1902 — Fri, 04 Jul 2014 06:55:18 GMT

Hi All,

I am having 10 excel files 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.

https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_First.xlsm
https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Second.xlsm
https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Third.xlsm
https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Fourth.xlsm
https://sharepoint.abc.com/def/TSM/project/123jpo345/Docs/Jan_Feb_Doc/JDJ_025M_1.0_Fifth.xlsm

Please help.......

topic How to load a sheet from multiple excel files?? in QlikView

How to load a sheet from multiple excel files??