| 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] |