How to Create Password-Protected Excel\CSV Files
Comments
-
Unfortunately, there is no direct method for creating password-protected Excel or CSV files. However, you can use the Zip Advanced step to compress the Excel or CSV file and apply a password to the zip file
For Advance zip step, please refer the below documentation:
https://documentation.decisions.com/step-library/docs/advanced-zip-step
-
This can be done by starting with a workbook that is already protected (either the sheet(s), workbook, or both) and then setting values through a flow.
Here is a quick example:
1) Create a flow with a Create data step, set value step, and a form with a file download button (file data type).
2) For the create data step, create data of filedata type. Set the input to constant and load in an already protected workbook.
3) This is the constant workbook being added. You can see it is blank and it is protected, both the sheet and the workbook.
4) In the set value set, I'm using a simple "Test" to be in A1. When running the flow and downloading the new file, here is the result:
The sheet/workbook protection stays intact. Hope that helps!
Howdy, Stranger!
Categories
- 4.4K All Categories
- 86 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 111 Rules
- 276 Administration
- 215 Portal
- 498 General Q & A
- 718 Forms
- 351 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 188 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 70 Repository
- 231 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 27 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions