Load data all worksheets in an Excel workbooks in qliksenese

[arjunganisetti]

Hi All,

I am new to Qlik sense. Please help me to load all data sheets from an excel file with one loop.

[brunobertels · Accepted solution]

Hi

Try this link

https://community.qlik.com/docs/DOC-14663

Or this one :

https://community.qlik.com/docs/DOC-7860

Hope it helps

[arjunganisetti]

HI bruno , Thanks for your Quik reply. But in my excel sheet is not valid for below conditions

Above method  works only in below scenarios 2)  When all the sheets of excel files having the same number of Columns with the same name.

I have different columns and number of columns also different so could you please help me with this scenario. PFA for your reference

[brunobertels]

Hi

This link may help :

https://community.qlik.com/thread/146917

[arjunganisetti]

HI Bruno,

Thank You So much It is working.

[brunobertels]

Hi glad to read that