Create Activity

The Create activity enables the generation of a new Excel file. It simultaneously creates and opens the specified Excel workbook, preparing it for subsequent data manipulation or other operations within an automation workflow.

Field	Description	Requirement
Excel name	A unique reference name for the Excel file created by this activity. This name is used to refer to the Excel instance in subsequent activities.	Required
Excel file name	The full path, including the file name and extension (e.g., `.xlsx`), where the new Excel file will be saved.	Required
Overwrite	Specifies whether to overwrite an existing file or folder with the same name at the specified path.	Optional

Action Types & Examples

Overwrite: True

Format: Boolean (input value for Overwrite parameter)
Example Result: The activity successfully creates the Excel file, replacing any existing file or folder at the specified path.

Overwrite: False

Format: Boolean (input value for Overwrite parameter)
Example Result: The activity creates the Excel file if no existing file or folder is present. If an existing item is found, the activity fails with an error.

Implementation Examples

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

Execution Parameters - Activity: Create Excel File - Parameters.ExcelReferenceName: newExcel - Parameters.FilePath: C:RobustaNew_Excel.xlsx - Parameters.OverwriteExisting: true

Technical Notes

When the Overwrite field is set to true: If no file or folder with the same name exists at the specified path, a new Excel file is created. If a file or folder with the same name exists, the existing item is overwritten by the new Excel file.

When the Overwrite field is set to false: If no file or folder with the same name exists at the specified path, a new Excel file is created. If a file or folder with the same name exists, the activity will not proceed with creation and will raise an error, indicating that an item with the same name already exists in the directory.