mercredi 1 juin 2011

Convert PeopleSoft Excel files to native Excel format

PeopleSoft is delivered in standard with XML Publisher for reporting.
Most reports are generated to PDF or Excel format, but the Excel format is MHTML1 not Excel native BIFF2 format.
If you have the requirement to include some page setup, or some dynamic formulas, you need to convert your MHTML files to BIFF format.

I would recommend to use ExtenXLS 10 Java Spreadsheet SDK, by Extentech:

This library has the availability to read (and write) MHTML and to instanciate them as an Excel WorkSheet.

This library was enhanced for one of my customer and it works fine with PeopleSoft XMLP MHTML files.

Aucun commentaire:

Enregistrer un commentaire