5.36 ExcelService
The ExcelService provides a means for applications to create and read Microsoft Excel documents. Since Microsoft Excel is so widely used, Excel documents can be a convenient way to exchange data between trading units or partners. An application may also use the service for extracting subsets of data from a corporate database for further analysis or presentation in an Excel workbook.
This service uses the open source Apache POI classes. Refer to http://poi.apache.org/spreadsheet/.
Due to the dependence on Apache POI, the ExcelService requires JDK 1.5 over higher.
The Apache POI and ExcelService jar files are shipped as extra and can be downloaded from http://www.lansa.com/support by searching for ExcelService.
When adding images to a sheet, only PNG and JPEG formats are supported.
Related Services
The ExcelService is not dependent on other services.
Technical Specifications