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

[vishalgoud]

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

[MarcoWedel]

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