OPEN

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

 

                                                         Required

 

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

 

                                                         Optional

 

           >-- READONLY --------- *YES ------------------------->

                                  *NO 

 

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)

 

READONLY

Instead of the entire document being read into memory, document components are accessed from the file, this reduces the memory footprint.

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)