Hi,
I am working on a project where we have to export reports to excel sheet . The report updates itself frequently .
Basically the user exports a report to excel , formats it and stores it . He can allow our application to update that report data .
The problem is in these cases we want to preserve the formatting information provided by the user on that excel and merge the fresh report data with the format .
Has anybody done this ?
Thanks for any help.
Mohan
-
formatting reports on excel at runtime (2 messages)
- Posted by: Mohan Navaratna
- Posted on: April 30 2002 18:31 EDT
Threaded Messages (2)
- formatting reports on excel at runtime by Yu Hsin Seah on May 06 2002 05:35 EDT
- formatting reports on excel at runtime by Galen Beck on May 14 2002 12:11 EDT
-
formatting reports on excel at runtime[ Go to top ]
- Posted by: Yu Hsin Seah
- Posted on: May 06 2002 05:35 EDT
- in response to Mohan Navaratna
try jexcelapi http://www.andykhan.com/jexcelapi/ -
formatting reports on excel at runtime[ Go to top ]
- Posted by: Galen Beck
- Posted on: May 14 2002 12:11 EDT
- in response to Mohan Navaratna
The POI project on jakarta provides a package for this as well.
http://jakarta.apache.org/poi/
There's a partial list of some alternatives at:
http://jakarta.apache.org/poi/hssf/alternatives.html