Exporting table data to MS-Excel Sheet 2000

[Former Member]

Dear All,

I just wanted to export my webdynpro table data to MS-XL 2000 version.

I know how to do it in XL-2003.

pl help.

Thanks & Regards

Manoj Sahoo

[former_member616106]

please suggest me to do it in 2003

[mynynachau]

Please ask your own question here:https://answers.sap.com/questions/ask.htmlso community members can provide you helpful answers.

[Former Member · Accepted solution]

Hi Manoj ,

You can use JExcel API to Export table data into Excel 2000. Itried it works fine For me.

you can ues this below link

/people/subramanian.venkateswaran2/blog/2006/10/02/enhanced-file-upload--uploading-and-processing-excel-sheets

regards,

Naga Raju

[Former Member · Accepted solution]

I am getting following error.

<b>java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook</b>

<b>java.lang.NoClassDefFoundError: jxl/write/WritableWorkbook</b>

pl help.

Regards

Manoj

Message was edited by:

Manoj Sahoo

[Former Member · Accepted solution]

Hi,

The POI jar (poi-2.5.1-final-20040804.jar or whatever it is now) is found in the lib folder with the download. If your CLASSPATH does not include this file, you will get this exception.

Regards,

Satyajit.

[Former Member · Accepted solution]

Where to chnage CLASSPATH in Local PC, where i am developing or in Server??

regrads

Manoj Sahoo

[Former Member · Accepted solution]

Hi,

It should be where you are developing.

Regards,

Satyajit.

[Former Member · Accepted solution]

Hi Satyajit.

Set the CLASSPATH but still getting error. re-started the PC also.

I am developing it in local PC but i am deploying it to server and its running on server not in local PC. Kindly suggest

regrads

Manoj

[Former Member · Accepted solution]

Thanks to all of you,

Thanks Naga Raju my problem solved , it works.

Regards

Manoj Sahoo

[Former Member · Accepted solution]

hai

i got this problem can u tell me how to solve

thank u

satish

[Former Member]

Hi Manoj,

I am trying lot to export my data to excel sheet from my webdynpro table . Can you tell my the procedure how canb i do that process.

Please reply!

Thnx in advance

Roshan Gupta

[Former Member]

Hi Roshan,

have you gone thru this link...

/people/subramanian.venkateswaran2/blog/2006/10/02/enhanced-file-upload--uploading-and-processing-excel-sheets

just tell me what exactly problem you are facing.

Regards

Manoj

[Former Member]

Manoj,

You need to use one of the third part libraries available to generate excel from Java. One of them is <a href="http://jakarta.apache.org/poi/hssf/index.html">POI - HSSF</a> from Apache Jakata project.

Cheers,

~kranthi

[Former Member]

Hi Manoj,

Go through this link to export the data to MS-Excel, it also provides you the sample application and PDF.

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/downloaditem?rid=/library/uuid/1208c2cd-0401-0010-4ab6-f4736074acc6">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/downloaditem?rid=/library/uuid/1208c2cd-0401-0010-4ab6-f4736074acc6</a>

Regards,

Jhansi

[Former Member]

This link is not working.

Can you please provide the correct link...

KN

[Former Member]

See this link.

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

Regards

Manoj Sahoo