Open an encrypted .xlsx with a password and read the sheet contents into a DataTable. Use this when the file uses ECMA-376 encryption that plain Excel readers cannot decrypt.
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
File Path filePath | file | Required | — | — |
Password password | string | 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
Auto Fill Range
Fill a source cell's formula or value across a range, adjusting relative references like dragging the Excel fill handle. Absolute references (with $) stay pinned.
Close Excel Workbook
Save and close the Excel file
Convert Excel to PDF
Export the workbook (or a single sheet) to PDF, preserving layout, charts, and conditional formatting.
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Create Pivot Table
Create a summary table to analyze data
Delete Excel WorkSheet
Remove a sheet from an Excel workbook