Skip to content

Save Activity

The Save activity manages the persistence of Excel files after operations are performed. It provides options to save, save as, save and close, or save as and close the active Excel workbook. This activity ensures that all changes made to an Excel file are properly stored according to the specified action.

Field Description Requirement
Excel name The reference name of the Excel file which has already been opened or created is chosen from the dropdown. Required
Action The desired operation is selected from the available options: SAVE, SAVE AS, SAVE_AS_AND_CLOSE, or SAVE_AND_CLOSE. Required
Excel file name The file path is written. If the SAVE AS action is selected, specify the full path and desired file name, including the extension. Optional

Action Types & Examples

SAVE

  • Format: string
  • Example Result: SAVE

SAVE AS

  • Format: string
  • Example Result: SAVE AS

SAVE_AS_AND_CLOSE

  • Format: string
  • Example Result: SAVE_AS_AND_CLOSE

SAVE_AND_CLOSE

  • Format: string
  • Example Result: SAVE_AND_CLOSE

Implementation Examples

Field Setup - Excel name: newExcel - Action: SAVE AS - Excel file name: C:\New_Excel.xlsx

Execution Parameters - actionType: SAVE AS - targetExcelName: newExcel - outputPath: C:\New_Excel.xlsx

Technical Notes

When using the SAVE AS action, the Excel file name parameter is mandatory and must specify the full path and desired file name, including the extension. If a file with the same name already exists at the specified path, it will be overwritten without a prompt. Ensure the specified path is accessible and has appropriate write permissions.