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'.