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)