topic Export to xls in QlikView

Export to xls

Anonymous — Wed, 23 Feb 2011 08:36:14 GMT

I have a pivot table that filter the datas trought 3 macros. How could I write a macro that export the 3 results into a xls file?

Thanks for help
Gimo

Export to xls

Wed, 23 Feb 2011 09:33:19 GMT

Did you try this?

1. Create a button.

2. Add to its Action an External Action type : Export.

3. Setup the action as required:

a. select the fields as needed

b. mention the path to save the excel. By default it would say, .qvo. Replace it with .xls

c. do the number formatting if needed.

d. Ok, Ok

4. Click the button.

5. Check the path you have mentioned earlier.

Do tell if this suffices or not.

Export to xls

suniljain — Wed, 23 Feb 2011 09:43:22 GMT

'To Excel Generate
set obj = ActiveDocument.GetSheetObject("CH703")
obj.ExportEx "E:\Qlikview\Prima\PPT\Department_Loadinng.xls",5
set obj = ActiveDocument.GetSheetObject("CH704")
obj.ExportEx "E:\Qlikview\Prima\PPT\Top_5_Project.xls",5
set obj = ActiveDocument.GetSheetObject("CH705")
obj.ExportEx "E:\Qlikview\Prima\PPT\0HrsProject.xls",5