Lock and Unlock Excel File
- 07 Nov 2024
- 1 Minute to read
- Print
- DarkLight
Lock and Unlock Excel File
- Updated on 07 Nov 2024
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
| Step Details | |
| Introduced in Version | 9.4.0 |
| Last Modified in Version | 9.4.0 |
| Location | Data > Excel & CSV |
The Lock Excel File step and the Unlock Excel File step are used to manage password protected Excel files. As their names suggest they can be used to add password protection to a Excel file and then unlock a spreadsheet with password protection.
Prerequisites
The password for the Excel file being unlocked is needed.
Lock Excel File Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| Excel Document | The Excel document. This can be pulled through any method that handles FileData, such as a Form. | FileData |
| Password | This password will be used to lock the Excel document. | String [System] |
Outputs
| Property | Description | Data Type |
|---|---|---|
| LockExcelFile1_Output | The Excel file is now locked. | FileData |
Unlock Excel File Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| Excel Document | The Excel document. This can be pulled through any method that handles FileData, such as a Form. | FileData |
| Password | This is the password that is used to unlock the Excel document. | String [System] |
Outputs
| Property | Description | Data Type |
|---|---|---|
| UnlockExcelFile1_Output | The unlocked Excel document. | FileData |
Step Changes
| Description | Version | Release | Developer Task |
|---|---|---|---|
| The Lock Excel File and Unlock Excel File steps have been added to the platform. | 9.4 | November 2024 | [DT-041848] |
Was this article helpful?
