How to read data from a table and autopopulate in an excel sheetin webdyn?

[Former Member]

i have a problem. i can auto populate a table in my webdynpro application. but how do i auto populate an excel sheet from this table ?

[Former Member]

There is a brandnew tutorial by Bertram Ganz on this topic. It will soon appear on SDN.

Basic idea (works with Excel 2003): Export the context data into XML format, store this XML data in a web resource, use the WDWebResource API to access and download the Excel file.

Armin

[Former Member]

thanks.But noufal i think tats applicable only in ABAP Programming.

[Former Member]

Hi,

Check the weblog "Create an excel file from JAVA using HSSF api"

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

This will solve your problem.

Regards,

Santhosh.C

[Former Member]

try the following link