Syntax

Example

Description/Remarks

EXCEL_CREATE "filename"

EXCEL_CREATE "F:\ Service\HourlyReport.xls"

This command creates a new file in Microsoft Excel format.

If the specified file already exists, this command deletes the existing file and creates a new file.
 

IF (EXCEL_ERROR > 0),
(MESSAGE EXCEL_ERRORDESC)
+ GOTO [A1]

If the specified file exists and is being used by another application, GainSeeker cannot create the file.  It is best practice to make sure the file creation is successful by immediately checking the value of EXCEL_ERROR before proceeding further in the template.  See the example at left.
 

See also: Creating a file in Microsoft Excel format.

For information on setting the contents of the new file, see EXCEL_WRITE, EXCEL_SETCOLW, EXCEL_SETMARGIN, and EXCEL_SETMISC.  

For information on opening and editing existing Excel files, see EXCELCOM_OPEN and EXCELCOM_WRITE.