Skip to main content

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 .xlsx for standard Excel files or .xlsm for macro-enabled files.

Common Errors

ErrorSolution
Path cannot be emptyProvide a valid file path
Directory does not existCreate the parent directory before creating the Excel file
Permission deniedEnsure you have write permissions for the target directory
File already existsThe file will be overwritten if it exists