create and send file to front-end for download.

[Former Member]

Hi,

In a nutshell I need to give users the possibility to download the contents of a table as a CSV file.

From what is understood, this would happen like this:

1)loop over the context node and write a file (table.csv) with the contents of each cell separated with a semi-colon. (or is there an API available to write the contents of an entire node/table)

2)send this file to the front-end so that a file download automatically begins and user can save it on the hard-disk.

Has someone done this before? If so, is it possible to share the code?

As usual, big points will be awarded.

Thanks!

faB

[Former Member]

Hi faB,

What you are trying is achieved very easily using HSSF API. You can download required three JAR files for this API from internet.There are all methods available in this API to read and write data into excel file with formatting also.

Just have a look at the following weblog for the same.

/people/prakash.singh4/blog/2005/03/16/create-an-excel-file-from-java-using-hssf-api

Regards,

Bhavik

[Former Member]

Hi FaB,

Have you resolved your problem? If no then please update otherwise close this thread.

Regards,

Bhavik

[Former Member]

Hi faB,

Refer "Exporting Context Data into Excel Using the Web Dynpro Binary Cache" by Bertram Ganz. This document will be very much helpful for you in exporting the context data into excel.

You can get the sample code and corresponding documentation from the following link

"Tutorial on Excel Export Using the Web Dynpro Binary Cache - 34"

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webas/webdynpro/tu... on excel export using the web dynpro binary cache - 34.htm

You can also use HSSF API for exporting the context data into excel

"Create an excel file from JAVA using HSSF api" by Prakash Singh

/people/prakash.singh4/blog/2005/03/16/create-an-excel-file-from-java-using-hssf-api

Regards,

Santhosh.C

[Former Member]

Hi Fab

Refer to this link.

regards

Kishore