ExcelOpen

ExcelOpen keeps an Excel file open for speeding up large numbers of write operations.

This function creates a FileHandle object in its execution path that can be used by the ExcelWrite function to write to the opened file. You can also use the SetValue function to assign values to the FileHandle's 'Append' property to add content that way.


Properties

File path

The path to the file to keep open for writing.

File does not exist

Options:

  • Create file
  • Copy template
  • Throw exception

Template file

Available when the File does not exist option is 'Copy template'.