topic Re: Export to excel in QlikView

Export to excel

Mon, 11 Aug 2014 06:28:26 GMT

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!

Re: Export to excel

amit_saini — Mon, 11 Aug 2014 06:37:19 GMT

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,

Re: Export to excel

Mon, 11 Aug 2014 06:49:36 GMT

Hi,

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

on the bottom select On BIFF Exports

Hope this helps,

Vivek

Re: Export to excel

Mon, 11 Aug 2014 07:03:18 GMT

Hi Amit,

We are using ajax client. will the macro work?

Re: Export to excel

Mon, 11 Aug 2014 07:07:26 GMT

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!

Re: Export to excel

amit_saini — Mon, 11 Aug 2014 07:07:31 GMT

No it won't work with Ajax.

Thanks,

Re: Export to excel

Mon, 11 Aug 2014 07:13:49 GMT

Hi Michal,

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

you can do this using macro.

Regards,

Vivek