EXCEL_OPEN
Opens an excel file.
Description
Opens an excel file. In order to be able to read from and write to an excel file, it first has to be opened. The excel file has to already be saved to the specified file path for the open command to work. Descript can only work with 1 excel spreadsheet at a time. This command specifies the excel file on which operations can be done later in the script run.
If the file is already open, then this command will open it again in another window. If there is another excel that was opened within the current script run and is still open, then this command will close that one, and open the new one at the given file path.
Syntax
EXCEL_OPEN [File path]
Command parameters
| Command parameter | Assignment | Value format | Input options |
|---|---|---|---|
| File path | Required | String | Local, variable |
File path:
Path, file name and extension of the excel file.
Sample code
EXCEL_OPEN c:\Temp\Sample_Excel.xlsx