Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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 ?

Partner
Partner

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 II

Re: need to load all sheets at time ?

like this? :

Aufnahme_2017_07_24_09_52_33_107.gif