Create Excel
Creates a new Excel file at the specified path with a default worksheet.
Common Properties
- Name - The custom name of the node.
- Color - The custom color of the node.
- Delay Before (sec) - Waits in seconds before executing the node.
- Delay After (sec) - Waits in seconds after executing the node.
- Continue On Error - Automation will continue regardless of any error. The default value is false.
info
If ContinueOnError property is true, no error is caught when the project is executed even if the Catch node is used.
Input
- Path - Full path where the new Excel file will be created (e.g.,
C:\Documents\new_report.xlsx). The file extension determines the format (.xlsx,.xlsm, etc.).
Output
This node does not output a file descriptor. After creating the file, use the Open Excel node to work with it.
Options
This node has no additional options.
Example
Creating a new Excel file:
// Path: C:\Reports\monthly_report.xlsx
// This creates a blank workbook with one default sheet
Creating an Excel file with macros support:
// Path: C:\Automation\macro_enabled.xlsm
// Use .xlsm extension for macro-enabled workbooks
Tips
- The file is created and immediately closed by this node. Use Open Excel afterwards to work with the file.
- If the directory doesn't exist, you'll get an error. Create the directory first using File System nodes if needed.
- The created workbook contains one default worksheet named "Sheet1".
- Use
.xlsxfor standard Excel files or.xlsmfor macro-enabled files.
Common Errors
| Error | Solution |
|---|---|
| Path cannot be empty | Provide a valid file path |
| Directory does not exist | Create the parent directory before creating the Excel file |
| Permission denied | Ensure you have write permissions for the target directory |
| File already exists | The file will be overwritten if it exists |