Export to excel.

[ankit777]

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?

[deepakk]

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

[anbu1984]

Export table to Excel with a button

[its_anandrjs]

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

[#5]

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

fill what you want to launch...

hope this is what you want

[ankit777]

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.

[#7]

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

[anbu1984]