how to load multiple sheets with same/Different columns from single excel into Qlikview..??

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

we have a big excel file which contains 126 sheets , we are not going to load all sheets but we load almost 30 sheets.

or we load few selected sheets lets take first 30 sheets.

and we are not sure about the data in each and every sheet i mean it will be different number of columns with different name of each column in each sheet.

we need a standard load method to load first 30 sheets into Qlikview.

Please help us with the script/work around which meets above requirement.

Thanks in advance.

Best Regards,

Vishal

Re: how to load multiple sheets with same/Different columns from single excel into Qlikview..??

MarcoWedel — Mon, 12 Dec 2016 22:42:44 GMT

maybe helpful:

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

Re: Loading multiple sheets from excel

Load Multiple excel sheets using For loop

regards

Marco

topic Re: how to load multiple sheets with same/Different columns from single excel into Qlikview..?? in QlikView

how to load multiple sheets with same/Different columns from single excel into Qlikview..??

Re: how to load multiple sheets with same/Different columns from single excel into Qlikview..??