formatting reports on excel at runtime

Discussions

XML & Web services: formatting reports on excel at runtime

  1. formatting reports on excel at runtime (2 messages)

    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
  2. try jexcelapi http://www.andykhan.com/jexcelapi/
  3. 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