Load multiple excel files with different sheet names in Qlik sense

[qlikuser222]

Hello All,

I am trying to load multiple excel files with different names and different sheet names into Qlik sense.

Example:

Excel files are named as Test1.xlsx, Test2xlsx, Test2.xlxs etc  with different sheet names like Data, Sheet1, Key etc which has same data.

Can anyone please help me to achieve it?

Thanks

[Chanty4u · Accepted solution]

Here is some of the ideas provided have a look

https://community.qlik.com/t5/Qlik-Sense-App-Development/Multiple-Excel-files-with-different-Sheet-n...

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/ScriptControlStatements/For%2...