Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Multiple excel with multiple sheets loading(sheets names are dynamic)

Hi experts,

I have 3 excel files in  one folder with same column names, i want to load all sheets data from all excel  files.

Here  i don't  want to connect any data base for excel files  and my sheet names are Dynamic.


Here i am attaching my  excel files.


Regards

Mahesh

7 Replies
qlikview979
Specialist
Specialist
Author

I tried that,i am not able to achieve that. if its possible prepare a sample app with my attached data.

-Mahesh

qlikview979
Specialist
Specialist
Author

Hi Experts,

stalwar1kush141087dvqlikviewavinashelite

any one can help me on this.

-Mahesh

jonathandienst
Partner - Champion III
Partner - Champion III

You will need to loop over the files using the above selections and in each, loop over the sheets using the solution here Need Help with loading multiple sheets of an Excel file

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Kushal_Chawda

try like below,

Just define your excel file pathand QVD path.

Dynamically Loading Multiple Excel Files

qlikview979
Specialist
Specialist
Author

Hi All,

Sorry for delay.

My Machine doesn't have Qv right now, if its possible can any one  share script along with my all files  data in table  box.

-Mahesh

qlikview979
Specialist
Specialist
Author

Hi Kush bro,

I defined my excel and qvd path, then i go for reload its showing below error

Here i am sending my files  with qv app.please check and let me know where i am wrong.

Capture.PNG

Regards,

Mahesh