Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
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..
Regards,
Helen0
see this thread
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.
regards
tim
Hi Helen,
I have Done Below Code As follows:
Let vFileName ='C:\Users\USER-12\Desktop\Multi Sheet Excel.xls';
Temp_Sheets:
LOAD Sheet as S // Number of Sheets:like I Have 3 sheets 1 2 3 so i Give 3 Value in field Sheet
FROM
(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)
Data:
LOAD
*
FROM $(vFileName)
(biff, embedded labels, table is [$(vSheetNo)$]);// Sheet Name must be in sequence like 0 1 2
next
Thanks ,
Arvind Patil
like this? :