Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arjunganisetti
New Contributor

Load data all worksheets in an Excel workbooks in qliksenese

Hi All,

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

1 Solution

Accepted Solutions
brunobertels
Valued Contributor

Re: Load data all worksheets in an Excel workbooks in qliksenese

5 Replies
brunobertels
Valued Contributor

Re: Load data all worksheets in an Excel workbooks in qliksenese

arjunganisetti
New Contributor

Re: Load data all worksheets in an Excel workbooks in qliksenese

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
Valued Contributor

Re: Load data all worksheets in an Excel workbooks in qliksenese

arjunganisetti
New Contributor

Re: Load data all worksheets in an Excel workbooks in qliksenese

HI Bruno,

Thank You So much It is working.

brunobertels
Valued Contributor

Re: Load data all worksheets in an Excel workbooks in qliksenese

Hi glad to read that