Question Re: Export Data to Excel sheet in Technology Q&A

Export Data to Excel sheet

Former Member — Sun, 08 Mar 2009 08:54:22 GMT

Hi,

I want to export data to Excel sheet from the table which will be there in that particular view. And that excel sheet should be store in the Particular system. can any one tell the procedure and code to do it.

Regards,

H.V.Swathi

Re: Export Data to Excel sheet

Former Member — Sun, 08 Mar 2009 13:08:54 GMT

There are Sample Applications Present in SDN , and you can find the Project which you can import your NWDS and use that Component , and you can directly export data from Table to Excel Sheet .

Please do search for the sample application you can certainly find the Project.(EXPORT TO EXCEL ) .

Re: Export Data to Excel sheet

Former Member — Sun, 08 Mar 2009 17:01:58 GMT

Check out this article by Ayyapparaj: https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0cc41cb-9576-2b10-99a6-ab90ef28c73b

Re: Export Data to Excel sheet

Former Member — Mon, 09 Mar 2009 04:13:47 GMT

Hi,

Thanks for ur reply. But i am not getting the proper jar file for this application. Can u tell where do i get the proper jar file for this. i e Jexcelapi.jar.

Regards,

H.V.Swathi

Re: Export Data to Excel sheet

Former Member — Mon, 09 Mar 2009 04:21:03 GMT

you have to Download the Jexcelapi.jar file .

Re: Export Data to Excel sheet

former_member192434 — Mon, 09 Mar 2009 05:30:01 GMT

Hi Swathi,

Download the XLF.jar file from given location below:

http://www.java2s.com/Code/Jar/Spring-Related/jxl.jar.htm

Thanks

Re: Export Data to Excel sheet

former_member185086 — Mon, 09 Mar 2009 05:44:28 GMT

1. First u have to read the data from excel and get all data into any Node and display it into table .

for this i have provided the line by line code in this [thread|;

2. Now from table u can export it into a excel sheet in any format (xls ,xml etc).

for export follow this [thread|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0cc41cb-9576-2b10-99a6-ab90ef28c73b]

Hope it help you

Best Regards

Satish Kumar

Re: Export Data to Excel sheet

Former Member — Mon, 09 Mar 2009 07:24:55 GMT

Hi,

I want to export the data to personal system how it is possible. i e in "C " drive.

How it is possible.

Regards,

H.V.Swathi

Re: Export Data to Excel sheet

former_member185086 — Mon, 09 Mar 2009 07:33:10 GMT

Hi Swati

1. Use the file upload UI Element, to get from C: drive.

2. Bring all the data into Context Node and then export u want .

well what is scenario let us explain (get from same system and then put in same )

Best Regards

Satish Kumar

Re: Export Data to Excel sheet

Former Member — Mon, 09 Mar 2009 07:36:38 GMT

thanks for ur reply.

But my question is how to export data to export data to excel sheet which will store in personal system.

C:/xlsfiles/file.xls

Like this.

Regards,

H.V.Swathi

Edited by: H.V Swathi on Mar 9, 2009 9:45 AM