PDF4me Secure Excel action applies comprehensive password protection to Excel documents in Power Automate with multi-level security control. This powerful security feature supports three independent protection levels: file encryption (password to open), workbook structure protection (prevent sheet modifications), and worksheet content protection (prevent cell edits), with flexible password hierarchy allowing separate passwords for each level or single password for all, plus selective worksheet targeting and four protection types (Contents, Objects, Scenarios, All), perfect for confidential data protection, template security, and controlled access workflows across Microsoft 365.
Authenticating Your API Request
To access the PDF4me Web API through Power Automate, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Power Automate flows and PDF4me's powerful Excel security services.
Key Features
- Three Protection Levels: File encryption, workbook structure, worksheet content
- Independent Passwords: Use different passwords for each protection level
- Password Fallback: Automatically use main password if level-specific password not provided
- Flexible Worksheet Selection: Protect specific worksheets or all worksheets
- Protection Type Options: Contents, Objects, Scenarios, or All (comprehensive)
- 0-Based Indexing: Worksheet indexes use standard 0-based numbering
Parameters
Complete list of parameters for the Secure Excel action. Configure these parameters to control protection levels and passwords.
Important: Parameters marked with an asterisk (***) are required. At least one password must be provided for respective protection level. Worksheet indexes use 0-based numbering (0 = first worksheet).
| Parameter | Type | Description | Example |
|---|---|---|---|
| File Content*** | Base64 | Source Excel File Content • Map Excel file from previous action output • Supports Excel files from SharePoint, OneDrive, email attachments • Can be dynamically retrieved from flow variables • Must be valid Excel document (.xlsx, .xls formats) | [File Content from Get File] |
| File Name*** | String | Excel Document Name • Specify Excel file name with extension (.xlsx, .xls) • Used for processing and output file naming • Must include proper file extension • Supports dynamic naming from flow variables | data.xlsx |
| Password | String | File Encryption Password (Level 1) • Password required to open the file - encrypts entire file • Also used as fallback for workbook and worksheet protection if their specific passwords are empty • Optional - no file encryption if empty • User Experience: Prompts "Enter password to open this file" - without password, cannot open or view file at all • Case-sensitive | MyPassword123 |
| Protect Workbook | Boolean | Enable Workbook Structure Protection (Level 2) • True = protect workbook structure - prevents adding/deleting/renaming/moving/hiding worksheets • False = no structure protection (default) • Requires password (ProtectWorkbookPassword or Password fallback) • User Experience: Prompts "This workbook is protected" when trying to modify structure • Default: false | true |
| Protect Workbook Password | String | Workbook Protection Password (Level 2) • Password for workbook structure protection • Password Fallback: Priority 1: ProtectWorkbookPassword (if provided), Priority 2: Password (if provided) • Required if ProtectWorkbook = true and Password is empty • Case-sensitive | StructurePass |
| Protect Worksheets | Boolean | Enable Worksheet Content Protection (Level 3) • True = protect selected worksheets - prevents data modifications • False = no worksheet protection (default) • Requires password (WorksheetProtectionPassword or Password fallback) • User Experience: Prompts "The cell you're trying to change is protected" when trying to edit • Default: false | true |
| Worksheet Protection Type | String | Type of Worksheet Protection • "Contents" = protect cell values, formulas, formatting (prevents editing cells, changing formats) • "Objects" = protect charts, images, shapes, drawings (prevents moving, resizing, deleting objects) • "Scenarios" = protect what-if analysis scenarios (prevents creating, modifying scenarios) • "All" = full protection (Contents + Objects + Scenarios) - Default, read-only access • Case-insensitive | All |
| Worksheet Protection Password | String | Worksheet Protection Password (Level 3) • Password for worksheet content protection • Password Fallback: Priority 1: WorksheetProtectionPassword (if provided), Priority 2: Password (if provided) • Required if ProtectWorksheets = true and Password is empty • Case-sensitive | EditPass |
| Worksheet Names | String | Comma-Separated Worksheet Names • List of worksheet names to protect • Empty = protect all worksheets • Case-sensitive worksheet names • Union with WorksheetIndexes | Sheet1,Summary |
| Worksheet Indexes | String | Comma-Separated Indexes (0-based) • List of worksheet indexes to protect • 0-based indexing (0 = first sheet) • Empty = protect all worksheets • Union with WorksheetNames | 0,2 |
Output
The PDF4me Secure Excel action returns comprehensive output data for seamless Power Automate flow integration:
- Table
- JSON
- Flow Integration
Table View
Response data in a structured table format:
| Parameter | Type | Description |
|---|---|---|
| document | Base64 | Password-protected Excel document |
| Success | Boolean | true if operation successful, false if failed |
| Error Message | String | Error description (null if successful) |
| Errors | Array | List of detailed error information (empty array if successful) |
JSON Response Format
The raw JSON response from the action:
{
"document":"[Base64 Protected Excel Content]",
"Success":true,
"ErrorMessage":null,
"Errors":[]
}
Error Response Example (Missing Password):
{
"document":null,
"Success":false,
"ErrorMessage":"Password is required for workbook protection. Please provide either a main password or workbook protection password.",
"Errors":[
{
"Code":"PASSWORD_REQUIRED",
"Message":"Cannot protect workbook without password"
}
]
}
Power Automate Flow Usage
Use protected Excel files in subsequent actions:
- Secure Distribution: Send password-protected Excel files to stakeholders
- Read-Only Reports: Distribute reports with worksheet protection
- Template Security: Protect Excel templates from structure changes
- Confidential Data: Encrypt sensitive financial or personal data files
- Email Attachments: Send encrypted Excel attachments securely
- SharePoint Publishing: Upload protected Excel files to document libraries
Common Error Messages
Understanding and troubleshooting errors helps ensure smooth Excel security workflows:
| Error Message | Cause | Solution |
|---|---|---|
| "Request is empty" | Request object is null | Provide valid request object |
| "Document is empty" | Document object is null | Provide valid Excel document |
| "Password is required for workbook protection. Please provide either a main password or workbook protection password." | ProtectWorkbook = true but both passwords empty | Provide Password or ProtectWorkbookPassword |
| "Password is required for worksheet protection on '{worksheetName}'. Please provide either a main password or worksheet protection password." | ProtectWorksheets = true but both passwords empty | Provide Password or WorksheetProtectionPassword |
| "Invalid worksheet selection" | Worksheet name doesn't exist or index out of range | Use valid worksheet names or indexes (0-based) |
| "Available worksheets in workbook (X total)" | Informational message when worksheet validation fails | Use valid values from X available worksheets |
| "Error securing Excel file: {message}" | Generic processing error | Check file integrity and parameter values |
Workflow Examples
The PDF4me Secure Excel action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:
- Confidential Reports
- Template Distribution
- Read-Only Distribution
- Selective Protection
Automated Confidential Report Protection Workflow
Transform your sensitive data distribution with multi-level password protection:
Complete Workflow Steps:
- Trigger: Monthly financial report generation completed
- Get Financial Report: Retrieve Excel report from SharePoint
- Apply File Encryption: Set Password = "Finance2024!" for file opening
- Protect Structure: Set ProtectWorkbook = true, ProtectWorkbookPassword = "Structure456"
- Protect Worksheets: Set ProtectWorksheets = true, WorksheetProtectionPassword = "Edit789"
- Set Full Protection: WorksheetProtectionType = "All"
- Apply to All Sheets: Leave WorksheetNames and WorksheetIndexes empty
- Email CFO: Send protected file to CFO with passwords via separate secure channel
- Archive Protected: Store encrypted version in finance vault
Business Benefits:
- Secures 12 financial reports annually with three-tier protection
- Prevents unauthorized access with file encryption
- Ensures report integrity with structure and content protection
- Complies with SOX and financial data security requirements
Automated Template Protection Workflow
Streamline your template distribution with structure protection:
Complete Workflow Steps:
- Trigger: New employee onboarding initiated
- Get Master Template: Retrieve expense report template
- No File Encryption: Password = "" (employees can open freely)
- Protect Structure: ProtectWorkbook = true, ProtectWorkbookPassword = "TemplateAdmin"
- Protect Formula Sheets: ProtectWorksheets = true for "Calculations" sheet
- Set Worksheet Protection: WorksheetNames = "Calculations"
- Protection Type Contents: WorksheetProtectionType = "Contents"
- Leave Input Editable: "Expenses" sheet remains unprotected
- Email Employee: Send template with instructions
- Log Distribution: Record template sent to employee
Business Benefits:
- Distributes 30+ protected templates monthly automatically
- Prevents accidental formula or structure changes
- Allows employees to use templates without breaking them
- Reduces IT support requests by 70% for broken templates
Automated Read-Only Report Distribution Workflow
Optimize your report distribution with worksheet protection:
Complete Workflow Steps:
- Trigger: Weekly sales report generated on Monday at 8 AM
- Get Sales Report: Retrieve completed Excel report from SharePoint
- Light Encryption: Set Password = "SalesTeam2024" (shared team password)
- Protect All Sheets: Set ProtectWorksheets = true
- Use Same Password: Leave WorksheetProtectionPassword empty (uses Password)
- Full Protection: WorksheetProtectionType = "All"
- Apply to All: Leave worksheet selectors empty
- Email Sales Team: Send protected report to entire sales team
- Include Password: Provide password in email body or separate message
- Archive: Store read-only version in reports library
Business Benefits:
- Distributes 52 weekly reports with read-only protection
- Prevents accidental edits to finalized reports
- Ensures data integrity with worksheet protection
- Reduces report corruption incidents by 95%
Automated Selective Worksheet Protection Workflow
Enhance your data security with selective worksheet protection:
Complete Workflow Steps:
- Trigger: Master data file updated in system
- Get Master File: Retrieve Excel with reference and input sheets
- No File Password: Password = "" (easy access for team)
- Protect Reference Sheets: ProtectWorksheets = true
- Target Specific Sheets: WorksheetNames = "Reference,Lookup,Constants"
- Set Protection Password: WorksheetProtectionPassword = "RefData2024"
- Contents Only: WorksheetProtectionType = "Contents"
- Leave Input Sheets Open: "Input" and "Entry" sheets remain editable
- Email Team: Send partially protected file to data entry team
- Archive: Store in master data library
Business Benefits:
- Protects critical reference data while allowing input
- Prevents accidental reference data corruption
- Enables controlled editing by authorized users
- Reduces data integrity issues by 80%
Industry Use Cases & Applications
- Finance & Accounting
- Legal & Professional Services
- Human Resources
- Healthcare & Medical
- Sales & Marketing
- Operations & Manufacturing
Finance & Accounting Use Cases
- Financial Statements: Encrypt quarterly reports with multi-level protection
- Budget Templates: Protect template structure and formula sheets
- Audit Documents: Apply read-only protection to audit deliverables
- Payroll Files: Encrypt salary data with full protection
Legal & Professional Services Use Cases
- Client Documents: Protect confidential legal documents with encryption
- Contract Templates: Secure template structure from modifications
- Case Files: Apply read-only protection to finalized case documents
- Billing Reports: Encrypt client billing information
Human Resources Use Cases
- Employee Records: Encrypt personnel files with password protection
- Performance Reviews: Protect review templates from structure changes
- Salary Documents: Apply full protection to compensation data
- Benefits Enrollment: Protect reference sheets in enrollment templates
Healthcare & Medical Use Cases
- Patient Records: Encrypt medical records with HIPAA-compliant protection
- Lab Results: Protect result worksheets from unauthorized changes
- Treatment Protocols: Secure protocol templates from modifications
- Insurance Claims: Encrypt claim documents with patient data
Sales & Marketing Use Cases
- Price Lists: Protect pricing worksheets from unauthorized changes
- Client Proposals: Apply read-only protection to finalized proposals
- Sales Templates: Secure template structure and formula sheets
- Confidential Strategy: Encrypt strategic planning documents
Operations & Manufacturing Use Cases
- Quality Standards: Protect quality reference sheets from changes
- SOP Templates: Secure procedure template structures
- Inventory Data: Protect master inventory reference data
- Production Schedules: Apply read-only protection to published schedules