cancel
Showing results for 
Search instead for 
Did you mean: 

creating an Excel workbook using External Jars (JXL third party excel API)

Former Member
0 Kudos

Hi,

in DC i want to create a excel workbook from a table using JXL api, ie when button is pressed the a excel sheet should be created irrespective of version with the data of the table.

I have to use JXL api bcoz if i use excelToExport component which will work only for 2003 & above versions of Excel.

ie want to export the data of table into excel without version dependencies of excel.

Please give step by step information to create a excel from a table using JXL api.

Thanks in advance & will be appreciated

Thanks

Maha

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Use following PDF for exporting data to excel.

[Exporting Context Data into Excel Using the Web Dynpro Binary Cache|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a94353]

Please provide Points if helpful.

Regards

Surender Dahiya

Former Member
0 Kudos

@ Surender Dahiya: The link of pdf which you had sent will work only for the 2003 & above versions of Excel.

Former Member
0 Kudos

An exellent blog:

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

Or this may help you:

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

For further information, please use the search, there so much topics regarding Excel Im-/Export

Best regards

Edited by: Christopher Linke on Jun 2, 2008 5:19 PM

Former Member
0 Kudos

@ Christopher: i am getting page not found error when clecking to the link.