topic Re: Export to excel. in QlikView

Export to excel.

ankit777 — Thu, 17 Apr 2014 05:01:47 GMT

Hi all,

There is a option on charts "Export to excel".

Can I provide the same option on a button click so that as soon as the user clicks the button the chart opens in an excel.?

Do i require some macro for the same?

Re: Export to excel.

deepakk — Thu, 17 Apr 2014 05:19:14 GMT

Hi ,

If you just want to copy the values from chart to excel then below is the code.

sub ExporttoExcel

set obj = ActiveDocument.GetSheetObject("CH271")

vFilename = "C:\qv-reports\" & obj.GetCaption.Name.v & ".csv"

obj.Export vFilename,","

end sub

But this macro will not work on ajax mode. The user should be viewing the application on plugin mode.

Regards

Deepak

Re: Export to excel.

anbu1984 — Thu, 17 Apr 2014 05:20:41 GMT

Export table to Excel with a button

Re: Export to excel.

its_anandrjs — Thu, 17 Apr 2014 05:26:04 GMT

Add a action on button >> Export >> Setup >> Add field there >> click on export to File >> Check Include labels >> click radio button records >> type the location record like D:\Excelfile.xls

Re: Export to excel.

Thu, 17 Apr 2014 05:53:20 GMT

right click> new sheet object > button > actions > add > external > launch

fill what you want to launch...

hope this is what you want

Re: Export to excel.

ankit777 — Thu, 17 Apr 2014 05:54:34 GMT

hi,

What do i do if I want user to define the path to save the excel file.?

I want the excel to open when user clicks button and he gets to save it at his desired location.

Re: Export to excel.

Thu, 17 Apr 2014 06:05:50 GMT

Once he opens it he can save it wherever he wants, its a basic excel file after opening...

Re: Export to excel.

anbu1984 — Thu, 17 Apr 2014 06:50:48 GMT