Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
caiogil1
Contributor III
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?

I hope to learn a lot here and help if I can
2 Replies
Clever_Anjos
Employee
Employee

Are you using Sense?

caiogil1
Contributor III
Contributor III
Author

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

I hope to learn a lot here and help if I can