Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fabricecallegar
Contributor

loading multiple sheets from all xls files in a folder

Hi,

I'm using Qlik Sense

I have a folder with multiple excel files.

I would like to load each xls file of the folder and for each of them, I would like to load some sheets.

I specify that I don't know the number or the name of the sheet but I know I want to load only those with a particular symbol or cod in their name.

how can I do that ?

thank you for your help

Fabrice Callegari

Tags (2)
1 Solution

Accepted Solutions
fabricecallegar
Contributor

Re: loading multiple sheets from all xls files in a folder

Thanks Mark but I just found the solution.

Do as explained in this page Loading Multiple Excel Sheets Dynamically along with file name and sheet name.

and disable the standard mode (http://help.qlik.com/sense/2.0/en-US/online/?_ga=1.188385836.504149128.1429862976#../Subsystems/Hub/...to allow ODBC connections without libraries.

3 Replies
fabricecallegar
Contributor

Re: loading multiple sheets from all xls files in a folder

It works perfectly in qlikview with this solution : https://community.qlik.com/docs/DOC-7860.

But in Sense, I don't know use an ODBC connection with a variable...

Does anyone have a solution ?

mjm
Contributor III

Re: loading multiple sheets from all xls files in a folder

Hello Fabrice,

I dont know the exact syntax but I would point you in the direction of the for....each command. This will allow you to iterate through all of the files in the chosen folder. This should work as long as the sheets in each of the excel files are named the same.

If this doesn't help then I believe also doing a wildcard load (e.g *.xls) may help.

If this does help, then please mark my response as helpful and correct.

Thanks,

fabricecallegar
Contributor

Re: loading multiple sheets from all xls files in a folder

Thanks Mark but I just found the solution.

Do as explained in this page Loading Multiple Excel Sheets Dynamically along with file name and sheet name.

and disable the standard mode (http://help.qlik.com/sense/2.0/en-US/online/?_ga=1.188385836.504149128.1429862976#../Subsystems/Hub/...to allow ODBC connections without libraries.

Community Browser