Definition and Usage
This command saves an Excel file either by overwriting the current file or saving it as a new file with a specified path. It allows you to preserve changes made to an Excel workbook during automation workflows.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Please select an Excel instance to identify the instance to operate on |
| Yes | Must be created via the "Launch Excel" or "Get active Excel worksheet" command |
Save mode | Choose to overwrite the current file or save as a new file | Save, Save as | Yes |
|
Save file path | Enter the full path or select a location to save the Excel file |
| Yes | Required when "Save as" is selected |
Overwrite if exists | Select to overwrite the file if one with the same name exists |
| No | If not selected, an error will occur when a file with the same name exists |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables in the "Save file path" parameter by clicking on the variable icon and selecting a previously defined variable. This is particularly useful when you need to dynamically determine where to save files based on previous workflow steps or user input.
Notes
Before using this command, ensure that you have a valid Excel instance that has been created using either the "Launch Excel" or "Get active Excel worksheet" command.
When using "Save as" mode, make sure the directory path exists before saving the file.
The "Overwrite if exists" option is important when using "Save as" to prevent workflow interruptions due to file conflicts.
If using network locations for saving files, ensure proper access permissions are in place to avoid errors.