topic Re: Excel Sheets in QlikView

Excel Sheets

parvez933 — Fri, 07 Dec 2018 10:21:23 GMT

Hi Everyone!

Can I know is there any other way of loading multiple excel sheets instead of using "For EACH loop"

A.xls--->Sheet1, Sheet2, Sheet3, Sheet4

other than for each m in 'Sheet1', 'Sheet2', 'Sheet3', 'Sheet4'; load *; from ....... *.xls (;;..;;.;;. $(m));

Re: Excel Sheets

Gysbert_Wassenaar — Fri, 07 Dec 2018 11:43:28 GMT

You can use another kind of loop. But you will need a loop. One option is to use an ODBC connection to the excel file and use the SQLTABLES function to retrieve a list of tables that exist in the excel file. Each sheet will be a table in that list. By using th SQLTABLES function you load that list into a table and then you can iterate of the records of that table to load the data from the excel sheets. Heres' an example: https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-with-file-name/ta-p/1481095

Re: Excel Sheets

parvez933 — Fri, 07 Dec 2018 11:48:34 GMT

Hey Gysbert!

I gone through the shared link before
https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-with-file-name/ta-p/1481095

Here we need an ODBC connection to the excel. As the windows change the ODBC connections has to be updated 32/64 bit. It is clumsy.
Can I know is there any other ways to achieve apart from the 2 ways as above.

Re: Excel Sheets

Gysbert_Wassenaar — Fri, 07 Dec 2018 13:16:04 GMT

Sure, but even more cumbersome.

Re: Excel Sheets

parvez933 — Fri, 07 Dec 2018 13:24:35 GMT

Hi Gysbert!
Even, more cumbersome!!!! Ok I will try with shared link then we will go for others!