Excel Open
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
Section titled “Properties ”File path
Section titled “File path ”The path to the file to keep open for writing.
File does not exist
Section titled “File does not exist ”Options:
- Create file
- Copy template
- Throw exception
Template file
Section titled “Template file ”Only displayed when the File does not exist option is ‘Copy template’.
The file to copy if the target file does not exist.