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.

When adding images to a sheet, only PNG and JPEG formats are supported.

Related Services

The ExcelService is not dependent on other services.

The ExcelService supersedes the ExcelReadService due its superior capabilities, including supporting .xlsx format Excel files