Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to excel

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!

6 Replies
amit_saini
Master III
Master III

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

Not applicable
Author

Hi,

To Export Current selection in Excel go to User Preferences -> Export

on the bottom select On BIFF Exports

Hope this helps,

Vivek

Not applicable
Author

Hi Amit,

We are using ajax client. will the macro work?

Not applicable
Author

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!

amit_saini
Master III
Master III

No it won't work with Ajax.

Thanks,

AS

Not applicable
Author

Hi Michal,

I didn't find any in built functionality in qlikview to customize it

you can do this using macro.

Regards,

Vivek