Open an Excel file to read or edit it
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
File Path filePath | file | Required | — | — |
Visible visible | boolean | Optional | false | — |
Output Variable outputVariable | variable | Optional | ExcelWorkbook | — |
Output
ExcelWorkbookWorkbookExcel workbook instance for reading/writing data
SheetNamesArray
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
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today
Auto Fill Range
Copy a cell's formula down the column, like dragging the fill handle in Excel
Autofit Rows and Columns
Widen columns to fit their contents. Widths are estimated from the longest value rather than measured, and rows are handed back to Excel to fit when the file opens
Clear Filter
Show every row again and remove the filter