Data Extract From Excel and Various Sheets In It

[rahulsingh12]

Hi I have an excel with multiple sheets in it.

I want to load all the sheets of that excels at one go.

I tried for looping which doesnot seem to work.

Please let me know if anyone has tried this.

Regards,

[kenphamvn]

Hi

Try This

Set v_Concatenate ='';
For each SheetName in 'Sheet1','Sheet2','Sheet3'
$(v_Concatenate)
TABLE_NAME:
LOAD
    COL_1
FROM [lib://Desktop/AAABook1.xlsx]
(ooxml, embedded labels, table is $(SheetName));
set v_Concatenate ='Concatenate';
next;

Regards,

An Pham

[rahulsingh12]

Hi An Pham,

If the number of sheets I'll have is not fixed.

It can keep varying.So how to go about it.

Regards,

[tamilarasu]

Hi Rahul,

There are lot of threads out there related to your question. Have you checked any of those links. I think below one should work. If you have any issues, please attach a sample excel file to avoid back and forth replies (also you will get answers quickly).

How to load multiple sheets on excel file into ... | Qlik Community

[arvind1494]

check this thread it may help you

Loading Multiple Excel Sheets Dynamically along with file name and sheet name