Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

caiogil1
New Contributor III

Loading all sheets from an Excel file

Hi guys,

I need to load every sheet from this excel file. Each sheet is a week of the month, this specific file attached is only the data from October (each month has a specific file with the same layout).

I wanna know if there is some way that make the data load process automatic, I mean no need of a lot of script for each week(sheet), also there is the possibility that the sheet names change for a specific month.

Using the command SQLtables and a for-loop maybe this can help me, but I did not get a positive result yet.

Someone have this solution or a better idea? Or is not possible to do that?

2 Replies
Employee
Employee

Re: Loading all sheets from an Excel file

Are you using Sense?

caiogil1
New Contributor III

Re: Loading all sheets from an Excel file

Yes, I forgot to mention it. Qlik Sense 3.1 SR2

Community Browser