5 36 2 Using the ExcelService

LANSA Integrator

5.36.2 Using the ExcelService

Typical ExcelService Command Usage

Whether you are writing your client application in RDML / RDMLX or in a 3GL such as RPG, you have to complete the same basic steps.

For example, an application that reads an EXCEL spreadsheet would typically issue the following sequence of commands:

JSM(X)_OPEN

JSM(X)_COMMANDs

     SERVICE_LOAD

          OPEN

          READ / WRITE

          CLOSE

     SERVICE_UNLOAD

JSM(X)_CLOSE

Refer to Java Service Manager Clients for the command details that apply to your chosen development language.