Skip to content

Excel Create Activity

The Excel Create activity enables the generation of a new Excel file at a specified location. This activity simultaneously handles the creation and immediate opening of the newly generated Excel file, making it ready for subsequent operations.

Field Description Requirement
Excel name Specifies the reference name for the Excel file to be created within the automation process. Required
Excel file name Defines the full file path, including the file name and extension, for the new Excel file. Required
Overwrite When selected, this option allows the activity to overwrite an existing file or folder with the same name at the specified path. Optional

Action Types & Examples

Excel Name

  • Format: string
  • Example Result: newExcel

Excel File Name

  • Format: string
  • Example Result: C:\RobustaNew_Excel.xlsx

Overwrite Status

  • Format: boolean
  • Example Result: true

Implementation Examples

Field Setup - Excel name: newExcel - Excel file name: C:\RobustaNew_Excel.xlsx - Overwrite: true

Execution Parameters - Excel name: {{excelFileNameVariable}} - Excel file name: {{filePathVariable}} - Overwrite: {{overwriteFlag}}

Technical Notes

If the Overwrite parameter is set to true: If a file or folder with the same name does not exist in the specified directory, the activity creates the new Excel file. If a file or folder with the same name already exists, the activity overwrites the existing item with the new Excel file.

If the Overwrite parameter is set to false: If a file or folder with the same name exists in the specified directory, the activity will not create the new Excel file and will terminate with an error message: "There is folder already in the directory."