CREATE
The CREATE command is used to create a new Excel document for writing. Use the SAVE command and FILE keyword to save the created document. The optional USE keyword can be used to specify a template document used to create the new document.
Required
CREATE -------------------------------------------------------->
Optional
>-- FORMAT ----------- *XLS ------------------------->
*XLSX
>-- USING ------------ file path --------------------|
Keywords
|
FORMAT |
Use *XLS to the create Excel 97-2003 format. The default *XLSX creates the XML based format. |
|
USING |
The file path for an existing Excel document which is to be used to as a template to create a new document. The ExcelService determines the file format from the file path extension. |
Examples
RDML
USE BUILTIN(JSM_COMMAND) WITH_ARGS('CREATE') TO_GET(#JSMSTS #JSMMSG)
USE BUILTIN(JSM_COMMAND) WITH_ARGS('CREATE FORMAT(*XLS)') TO_GET(#JSMSTS #JSMMSG)
or
USE BUILTIN(JSM_COMMAND) WITH_ARGS('CREATE USING(template.xlsx)') TO_GET(#JSMSTS #JSMMSG)
RDMLX
use builtin(jsmx_command) with_args(#jsmhandle 'create') to_get(#jsmsts #jsmmsg)