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.