how to upload 2 excel files at a time

[#1]

Hi frnds,

i have 2 excel files in which it has 2 sheets each....

i want to load both of them at a tym.

in 1st excel file

1st sheet is

d sheet is

In 2nd excel seet we have

1st & 2nd sheet is

i want to load both the excel files using for loop?Plzzzzzzzzzzzzzzzzz helpppppppppppppppppppppppp

write the scripting code plssssss

[t_moutault]

Hi,

take a look at this :

// SUBPROGRAM : all xls files in repository

SUB ListeEnquetes(Root)

  //Récupération des fichiers enquête

  FOR Each File in filelist (Root&'\TEST*.xls' )

       IF FileSize('$(File)') > 0 then

            Enquêtes:

            LOAD

               *

            FROM

            [$(File)]

            (biff, embedded labels, table is Feuil2$);

       ENDIF

  NEXT File

ENDSUB

//Exécution du sous programme

CALL ListeEnquetes ('\\SRV\TEST')

[#3]

can u pls post the reply in English

[oknotsen]

The code is in English and perfectly understandable. The only thing not in English are the name of the SUB and the name of the table; they will work perfectly even when not in English.

Just copy-paste it and replace the none-code words by the names of your files, sheets and (table and sub) naming convention .

If you have any specific questions left, please let us know.

If not, please flag the topic as answered.

[#5]

Hi,

I got another method , can you see this attached files.

[#6]

• With that approach ,we will get one sheet at atime.......
• i want all the sheets in both two excel sheets

[#7]

1st excel file name is :Excel1

               in that the sheet names are  Sheet1 and Sheet2

2nd excel file name is : Excel2

                    in this file,the sheets are Sheet1 and Sheet2

Im new to qlik view....

Please write the exact code and i will copy paste

and i will run......

Waiting for the reply

[oknotsen]

Assuming the sheets have the same columns (which don't even have to be in the same order), the different sheets will automatically concatenate.

Did you try it?

[#9]

i know for

how to load multipe excel sheets from a single file

But my question is

How to load 2 excel files which has 2 sheets ezch

for the above scenario?

[krishna20]

Hi,

Please follow this link.hope it helps

Load Multiple excel sheets using For loop