Skip to Content
0
Former Member
Feb 19, 2009 at 03:38 AM

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

71 Views

Hi experts,

I am trying to implement the functionality of downloading the contents of a webdynpro screen to excel sheet. In order to implement the functionality of excel download i used the following blog.

[/people/subramanian.venkateswaran2/blog/2006/08/16/exporting-table-data-to-ms-excel-sheetenhanced-web-dynpro-binary-cache ]

In this blog they have used javaexcel api to implement the excel functionality. I face some problems

while implementing it.

i) The use of "Label label = new Label(0, 2, "A label record");

sheet.addCell(label); " is not supported. It says that a constructor for label with

(int, int, str) parameter is not available.

ii) Then i implemented it with "Label label = new Label("A label record"); " Then i deployed it. I got a runtime exception saying that " java.lang.ClassNotFoundException: jxl.format.CellFormat ".

This cellFormat is an interface available in the jar. I am using jexcelapi_2_6_9_1.4 version. Do i have to

download some other versions.

Please help. Thanks in advance.

Regards

Ramanan