Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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