Loading data into Qlik sense from multiple excel files and sheets

[mohammedsohail]

Hi Everyone,

I am trying to load data from multiple excel files, each file has around 10 sheets and I want to load one sheet that starts with a particular name and sheet name in all these excel files is not the same but starts with Output as prefix (ex: output1, output23, output_5 etc) and file names are month_Jan, month_Feb, month_mar etc

Is there a way I can load the data at single go

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

(ooxml, embedded labels, table is output1);]

[anat]

you have to use loop to load the data 

https://community.qlik.com/t5/QlikView-App-Dev/Load-data-from-multiple-worksheets-in-multiple-Excel-...