5 37 ExcelReadService

LANSA Integrator

5.37 ExcelReadService

The ExcelReadService 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 Java Excel API classes. Refer to http://jexcelapi.sourceforge.net.

When adding images to a sheet, only the Portable Network Graphics (PNG) format is supported.

Related Services

The ExcelReadService is not dependent on other services.

Technical Specifications

The following service properties control the locale, region and language values used when reading and writing workbooks:

  • excel.locale
  • excel.region
  • excel.language