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

8 Replies
rohit214
Creator III
Creator III
Author

any one...  please help

Not applicable

rohit214
Creator III
Creator III
Author

hi

i am not able to connect or make oledb connection because i don't have drivers.

thanks

rohit

Not applicable

I Suggest you install the drivers from MSDN.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Have a look at the example attached on your earlier post.

     http://community.qlik.com/thread/77235?tstart=0

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
rohit214
Creator III
Creator III
Author

Hi,

is there any other way?

thaks

rohit

rohit214
Creator III
Creator III
Author

please help me...any idea

Not applicable

If you can't do above steps. then you need to use Excel Splitter tool which will split the sheets into individual excel files then you can use the loop to teaverse each excel file and load the data.