Save and close the Excel file
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Save Changes saveChanges | boolean | Optional | true |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Convert CSV to Excel
Turn a .csv file into a .xlsx workbook. Quantities become numbers so they will sum, and reference numbers keep their leading zeros
Convert Excel to PDF
Save the workbook, or one sheet, as a PDF
Execute Excel Macro
Run an automated macro inside Excel
Manage Named Ranges
Name a range so formulas can say =SUM(Sales) instead of =SUM(Sheet1!$B$2:$B$500), and keep meaning the right cells when rows are inserted
Recalculate Excel Formulas
Recalculate the workbook's formulas and save. Use after writing values other formulas rely on
Refresh Workbook Data
Run every query, connection and PivotTable cache in the workbook again, waiting for the background ones to finish before saving. Needs Windows with Microsoft Excel installed