Discussion board where members can get started with QlikView.
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.
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