How to create password protected Excel Reports?
| FIRST CREATED ON 16 Jul 2025 I AUTHOR Emma Camacho |
To achieve the same functionality as the Excel's feature File > Info > Protect Workbook > Encrypt with Password
please follow these steps:
1) Create the Excel Report
2) Call the expression PasswordProtectReportDocument to assign a password to the Report
3) Distribute the Report
Example:
The EXECUTE CODE action looks like this:
The complete CODE looks like this:
The first parameter in the PasswordProtectReportDocument should match the name assigned in the CREATE REPORT DOCUMENT action.
The second parameter is an expression, therefore a field, variable, etc could be used instead of a hardcoded password.
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.