loading multiple excel files where the names and the sheets are different

[0li5a3a]

If the names of the excel files are like below scenario?

Scenario:

Excel file name abc dsadsadsadasdas.xlsx

     this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 saddsdnadnsabdasbnjknhd

Excel file name abc dsadsajdhsadhsadsajd.xlsx

     this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 bbcscsbds

Excel file name abc dsadnasjdaskifh.xlsx

      this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 asacsasadsadas

Excel file name abc sdadsnadnsadasdasjnhdasn.xlsx

     this contain 4 sheets and I want to load only sheet no 3 with this name: Top 60 ssda

Thanks in advance !

[seanbruton]

Hi there,

I have a small example to help you on the right path as I have also had this problem in the past.

So I created an excel file with three sheets.

the file is copied into an area when qlik sense has a connection to it.

I used the load script below to pull in data from various sheets names and name it various tables and not concatenate it.

[Top 20 saddsdnadnsabdasbnjknhd]:

FIRST 20 LOAD  [h1],

[h2]

FROM [lib://Connections (vtct_sbruton)/Testfilename.xlsx]

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

[Top 10 saddsdnadnsa]:

FIRST 10 LOAD  [h1],

[h2]

FROM [lib://Connections (vtct_sbruton)/Testfilename.xlsx]

(ooxml, embedded labels, table is Sheet2);

NoConcatenate

[Top 30 saddsdnadnsabd]:

FIRST 30 LOAD  [h1],

[h2]

FROM [lib://Connections (vtct_sbruton)/Testfilename.xlsx]

(ooxml, embedded labels, table is Sheet3);

I attached the files and images to help you.

I hope this helps.

[sunny_talwar]

Check if this will work for you

Re: Load from multiple Excel files just a specific sheet

[0li5a3a]

Hi ,

I can't used your example becasue I can't store the sheets names on the first sheets and secound the above scenario is different.

The sheets name are starting with Top 60 but can have hundreds different names.

thanks for help!

[0li5a3a]

it is any way to do this in Qlikview?

[sunny_talwar]

Sorry, but what is different?

[seanbruton]

Yes the load script is the same just your conenction is a bit different.

[seanbruton]

If all the files start with Top 60 then make the from part of the load script read

FROM [lib://Connections (vtct_sbruton)/TOP 60*.xlsx]

(ooxml, embedded labels, table is Sheet3);

[sunny_talwar]

I don't think the file name contains TOP 60... I believe it is the sheet name which contains Top 60

[0li5a3a]

the files names contains abc* and every files has a sheet which starts with Top 60*.

thanks