Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vishalgoud
Contributor III

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

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

1 Reply

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