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

[Former Member]

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

[Former Member · Accepted solution]

Wang,

check these links

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/webDynproJava-ExportingTableDataUsingOn-DemandStreams-SAPNW+7.0

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a9...

Thanks

Bala Duvvuri

[Former Member]

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

[Former Member]

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

[former_member192434]

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

[siddharth_jain]

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-89276e64b...

Regards

Siddharth

[Former Member]

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

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