need to load all sheets at time ?

[#1]

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

[zhadrakas]

see this thread

Re: loading all sheets data from excel

[#3]

i am getting some biff code error.

kindly try once

[zhadrakas]

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

[Kushal_Chawda]

see this

Dynamically Loading Multiple Excel Files

[arvind_patil]

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

[Frank_Hartmann]

like this? :