Discussion Board for collaboration on QlikView Scripting.
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.
any one... please help
Check out this link. Very nice post on Excel.
i am not able to connect or make oledb connection because i don't have drivers.
I Suggest you install the drivers from MSDN.
Have a look at the example attached on your earlier post.
is there any other way?
please help me...any idea
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.