Write a copy of the workbook in another format, leaving the original as it is. xlsx and csv need nothing installed; pdf, xls, xlsb and macro-preserving xlsm go through Excel on Windows
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Save As filePath | file | Required | — | The file to write. The original is left as it is |
Format format | enum | Optional | — | Leave unset to take it from the file name. xls, xlsb, xlsm and pdf need Excel installedxlsxcsvpdfxlsxlsbxlsm |
Sheet Name sheetName | string | Optional | — | Which sheet, for csv and pdf. Leave empty for the first sheet |
Output Variable outputVariable | variable | Optional | SavedFilePath | — |
Output
$outputVariableStringThe path of the file that was written
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Close Excel Workbook
Save and close the Excel file
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