Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit214
Creator III
Creator III

how to fetch all the exel sheet while reload

hi all,

In my data souce whhich is bunch of excel files, i want to reload all the exccel file in sigle shot i.e. while reload i want to fetch all the excel sheet in qv

and the format of my excel file islike a.xlsx and in that file sheet name is also a,

same for b.xlxs and sheet name is b ans so on...

please help me to short out this problem.

Thanks

Rohit

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Have a look at the attachment.

     Kindly change the path in script before reloading document.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
stevelord
Specialist
Specialist

Hi Kaushik, can you paste the text out to the body of the post?  I can't read other folks' QV files until I get off probationery period and company buys me a license.