Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rohit214
Contributor 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
Contributor III

Re: how to fetch all the exel sheet while reload

any one...  please help

Not applicable

Re: how to fetch all the exel sheet while reload

rohit214
Contributor III

Re: how to fetch all the exel sheet while reload

hi

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

thanks

rohit

Not applicable

Re: how to fetch all the exel sheet while reload

I Suggest you install the drivers from MSDN.

Re: how to fetch all the exel sheet while reload

Hi,

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

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

Regards,

Kaushik Solanki

rohit214
Contributor III

Re: how to fetch all the exel sheet while reload

Hi,

is there any other way?

thaks

rohit

rohit214
Contributor III

Re: how to fetch all the exel sheet while reload

please help me...any idea

Not applicable

Re: how to fetch all the exel sheet while reload

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.

Community Browser