XML & Web services: formatting reports on excel at runtime
- Posted by: Mohan Navaratna
- Posted on: April 30 2002 18:31 EDT
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.
try jexcelapi http://www.andykhan.com/jexcelapi/
The POI project on jakarta provides a package for this as well.
There's a partial list of some alternatives at: