Save data to cells or ranges in a spreadsheet
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Write Mode writeMode | enum | Optional | existing | existingnew |
Excel Instance excelInstance | variable | Optional | Not set | Shown when writeMode = existing |
New File Path newFilePath | file | Optional | Not set | Shown when writeMode = new |
Sheet Name sheetName | string | Optional | Not set | |
Data to Write dataTable | variable | Required | Not set | |
Start Cell startCell | string | Optional | A1 | |
Include Headers includeHeaders | boolean | Optional | true |
Output
WriteResultBooleanIndicates whether the write operation was successful
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row
Auto Fill Range
Copy a cell's formula down the column, like dragging the fill handle in Excel
Write CSV
Write a sheet out as a .csv file. Formulas are written as their answers, since a CSV has nowhere to put a formula
Write to Cell
Write a value, or an Excel formula, to a specific cell
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today