Skip to Content
avatar image
Former Member

Export data to excel sheet

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 12, 2009 at 06:51 AM

    Hi Swathi,

    As I understand, this query is in continuation of your thread: export-data-to-excel-sheet

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Mar 12, 2009 at 06:08 AM
    Add comment
    10|10000 characters needed characters exceeded