Discussion Board for collaboration on QlikView Scripting.
I am having months data in the Excel Sheet.
Every month it will added one more Sheet With new month, need to be loaded in a Single load dynamically.
Please find the attached excel, Can any help me on this..
see this thread
Re: loading all sheets data from excel
i am getting some biff code error.
kindly try once
see this thread.
Re: Load multiple excel files from Multiple excel sheetsinto QV
Steve Dark uploaded a qvw with a working sample for that load.
Dynamically Loading Multiple Excel Files
I have Done Below Code As follows:
Let vFileName ='C:\Users\USER-12\Desktop\Multi Sheet Excel.xls';
LOAD Sheet as S // Number of Sheets:like I Have 3 sheets 1 2 3 so i Give 3 Value in field Sheet
(biff, embedded labels, table is [0$]); // 0 is my default sheet where I mention my Total number of sheet
let vMaxSheet = peek('S', -1, 'Temp_Sheets');// Count of Sheets
DROP TABLE Temp_Sheets;
for vSheetNo = 1 to $(vMaxSheet)
(biff, embedded labels, table is [$(vSheetNo)$]);// Sheet Name must be in sequence like 0 1 2
like this? :