Export data to excel sheet

[Former Member]

Hi,

I want to export table data to excel sheet when i click a button. Now i have created a button and file download UI elements.

When i click a button it is storing excel sheet in server and when i click download it will download.

I want to do this download when i click the button only.

How can i do this.?

Regards,

H.V.Swathi

Edited by: H.V Swathi on Mar 12, 2009 5:50 AM

[Former Member]

Hi Swathi,

As I understand, this query is in continuation of your thread:

Your requirement looks like exporting data from wendynpro context (table) to excel while saving the same on local system...However since the file gets created on server it only opens in a window with the server path. Can you not save this file which opens to your local system manually? AFAIK, you will not be able to create a file directly on a local system.

But, you may try one thing: the button which you are using to create excel, in OnAction() of that method (just after you finish the code for export to excel), call the onAction() of file download UI button... set the context for the file download before that...

Can you check this?

Regards,

Anagha

[Former Member]

Hi,

Thanks for ur reply.

But there is no action for file download UI element.

Regards,

H.V.Swathi

[Former Member]

Hi Swathi,

Sorry, my mistake. I think there is some supply function for the node that is linked to the data property of the filedownload UI... can it be called?

Regards,

Anagha

[Former Member]

Hi,

May be of use for you https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0cc41cb-9576-2b10-99a6-ab90ef28...

Regards

Ayyapparaj