topic Re: Data Extract From Excel and Various Sheets In It in QlikView

Data Extract From Excel and Various Sheets In It

rahulsingh12 — Thu, 18 Jan 2018 05:57:19 GMT

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,

Re: Data Extract From Excel and Various Sheets In It

kenphamvn — Thu, 18 Jan 2018 06:17:41 GMT

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

Re: Data Extract From Excel and Various Sheets In It

rahulsingh12 — Tue, 30 Jan 2018 05:07:49 GMT

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,

Re: Data Extract From Excel and Various Sheets In It

tamilarasu — Tue, 30 Jan 2018 06:08:14 GMT

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

Re: Data Extract From Excel and Various Sheets In It

arvind1494 — Tue, 30 Jan 2018 06:19:07 GMT

check this thread it may help you

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