Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a few issues with the export to excel.
1. when I export my tables, it gives me an excel file with a very strange and long file name. there is a way to change it? why isn't it the table name or something?
2. Is there a way to add to the excel file more details? for example the current filter selection, the date, the report title etc.
Thanks guys!
Michal,
Try this macro:
Sub ExportExcel1
vFile = ActiveDocument.Variables("vInput1").GetContent.String
'XLDoc.SaveAs "c:\Qlikview\Claro"& vFile &".xls"
set obj = ActiveDocument.GetSheetObject("CH580")
obj.ExportEx "Give your path here where you want to export the sheet\Test\"& vFile &".xls",5
End sub
Thanks,
AS
Hi,
To Export Current selection in Excel go to User Preferences -> Export
on the bottom select On BIFF Exports
Hope this helps,
Vivek
Hi Amit,
We are using ajax client. will the macro work?
Hi Vivek!
Thank you!! Is there a way to customize it? now it appears on the bottom of the excel and I want to change the location and the size.
Thanks!
No it won't work with Ajax.
Thanks,
AS
Hi Michal,
I didn't find any in built functionality in qlikview to customize it
you can do this using macro.
Regards,
Vivek