Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

need to load all sheets at time ?

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

6 Replies
zhadrakas
Valued Contributor

Re: need to load all sheets at time ?

Not applicable

Re: need to load all sheets at time ?

i am getting some biff code error.

kindly try once

zhadrakas
Valued Contributor

Re: need to load all sheets at time ?

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

Re: need to load all sheets at time ?

arvind_patil
Valued Contributor III

Re: need to load all sheets at time ?

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
Honored Contributor

Re: need to load all sheets at time ?

like this? :

Aufnahme_2017_07_24_09_52_33_107.gif

Community Browser