Open an Excel file that needs a password and read it into a table
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
File Path filePath | file | Required | — | — |
Password password | password | Required | — | — |
Sheet Name sheetName | string | Optional | — | Optional. Defaults to the first sheet in the workbook. |
Output Variable outputVariable | variable | Optional | ExcelData | — |
Output
ExcelDataDataTableData read from the password-protected sheet
RowsArrayColumnsArrayRowCountNumber
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Read CSV
Import data from a comma-separated values file
Read Excel
Get data from cells or ranges in a spreadsheet
Read Excel Cell
Read the value from a specific cell in an Excel worksheet, or the formula behind it
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