OPEN

LANSA Integrator

OPEN

The OPEN command is used to open a specific Excel document for reading or writing.

 

                                                         Required

 

 OPEN -------- FILE ------------- file path --------------------|

 

Keywords

FILE

The path and file name to be opened. The file name should include an appropriate Excel file extension, for example XLSX for an Excel Workbook.

For example:

 

use builtin(jsmx_command) with_args(#jsmhandle 'open file(product.xlsx)') to_get(#jsmsts #jsmmsg)

 

use builtin(jsmx_command) with_args(#jsmhandle 'close') to_get(#jsmsts #jsmmsg)

 

Examples

RDML

 

USE BUILTIN(JSM_COMMAND) WITH_ARGS('OPEN FILE(product.xlsx)') TO_GET(#JSMSTS #JSMMSG)

 

RDMLX

 

use builtin(jsmx_command) with_args(#jsmhandle 'open file(product.xlsx)') to_get(#jsmsts #jsmmsg)