The CREATE command is used to create a new in-memory Excel document for writing.

Use the SAVE command and FILE keyword to save the created document to a file.

The optional USE keyword can be used to specify a template document used to create the new document.

Syntax:

Command

Keyword

Value

Developer notes

CREATE

FORMAT

*XLS

Create Excel 97-2003 format.

*XLSX

Default.

USING

value

Optional. File path.

Example

    CREATE

    CREATE USING(/folder/file.xlsx)