topic Re: Load Specific Sheets from multiple Excel Files in QlikView

Load Specific Sheets from multiple Excel Files

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have the whole set of Sheet names needed to load from multiple Excel Files , any ideas of how to load those specific Sheets from multiple excel Files?

* Right know I can do the loading for just for 1 file and it has to be replied for the rest of the sheets of every file

* All this specific sheets share the same structure.

* The name of each Sheet has different length.

Re: Load Specific Sheets from multiple Excel Files

swuehl — Wed, 18 May 2016 23:53:59 GMT

Maybe you can prepare a table (e.g. an INLINE table) with two fields, Excel file names and Excel sheet names to load.

Then loop over this table (and alternative might be to use a FOR EACH .. IN () ... NEXT loop) record by record and built your LOAD .. FROM [$(vFileName)] (... table is $(vSheetName)) statement accordingly.

If you search around the forum, you should find some examples on how to do this in detail.

Re: Load Specific Sheets from multiple Excel Files

Thu, 19 May 2016 15:29:20 GMT

Swuehl:

Thank you very much for your answer,

I ´ve tried the For Each..... I know it should work but I ´m not doing correct the specification for sheets to be loaded, I already have my LOAD .. FROM [$(vFileName)] (... table is $(vSheetName)) working fine I know I´m just almost done , just that part loading all the sheets specified keeps me a Little bit worried

Re: Load Specific Sheets from multiple Excel Files

swuehl — Thu, 19 May 2016 16:10:39 GMT

If you could post your current script code that does the loops & sheet loading, it would be easier to maybe spot a potential issue.

Re: Load Specific Sheets from multiple Excel Files

Thu, 19 May 2016 17:22:21 GMT

ok , I ll work on an example, just not to show data from the company, thank you very much