Skip to Content
avatar image
Former Member

How does the WDJ download the data into a excel file?

Hi, experts,

I know that webdynpro for java application doesn't support ALV.

Does the webdynpro for java application has a tool that can download the data which is in the table ui element into a excel file ?

If the webdynpro for java application doesn't have this type's tool, I hope to get some hint for implement the function.

Do you give me some hint?

Best regards,

tao

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 11, 2008 at 01:12 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2008 at 09:02 AM

    Hi wang,

    You can use Link to URL UI element for this purpose.

    Please go through the following link for exporting table data to excel file

    Exporting table data to MS-Excel Sheet(enhanced Web Dynpro Binary Cache)

    you may also refer to the following link:

    http://help.sap.com/erp2005_ehp_03/helpdata/EN/df/d2844229ac173be10000000a155106/frameset.htm

    Edited by: Aishwarya Sharma on Oct 10, 2008 11:02 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2008 at 09:05 AM

    Hi,

    Check the following WIKI for Downloading Table data in Excel Sheet using On demand Resource streaming in WD java:

    https://www.sdn.sap.com/irj/sdn/wiki?path=/x/0mq

    Also Sample Source code Download link applicable for NW 7.0

    http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/900c73fa-e5ef-2910-bea8-89276e64bc8e

    Regards

    Siddharth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2008 at 09:08 AM

    Hi,

    You can export table data into Ms-Excel file by using this link

    /people/sap.user72/blog/2006/05/04/enhancing-tables-in-webdynpro-java-150-custom-built-table-utilities

    Aslo make sure required jar file(xlf.jar) file should be included into your java build path and lib folder of your application, otherwise it will give excepiton

    Thanks

    Anup

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2008 at 06:38 AM

    Hi

    please go through this link

    https://www.sdn.sap.com/irj/sdn/wiki?path=/display/wdjava/main

    u will find ur asn..

    Regards

    Ruturaj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2008 at 07:26 AM

    Hi,

    I had just done this requirement by following the following link, where this functionality is explained step and step procedure.

    [https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4210] [original link is broken] [original link is broken] [original link is broken];

    Just copy the code as specified in the above blog.

    Finally after doing all the things, just add a ToolbarLInktoURL UI element in the view layout and in properties of ToolbarLinktoURL UI change Text property with any text and reference property bind with context attribute ExcelURL which is of string type.

    Regards

    Raghu

    Add comment
    10|10000 characters needed characters exceeded