Summary

LANSA Integrator

Summary

INT011 - Create Excel Document

Important Observations

  • The ExcelReadService provides a means to create and read Microsoft Excel documents
  • You could use this to create documents to exchange between offices or with trading partners
  • You could also extract data from the corporate database for analysis and presentation purposes

Tips & Techniques

  • Data can be read from or written to a worksheet in a specified row and column range using a LANSA working list or a 3GL data structure
  • See Appendix B in the LANSA Integrator guide for RDML and RDMLX examples using ExcelReadService.
  • To create Excel files using the XSLX format, use the ExcelService.

What I Should Know

  • How to use the ExcelReadService to write to an Excel worksheet