PDF4me Excel icon

PDF4me Excel

Revolutionize Excel workflows with intelligent automation: dynamically manipulate spreadsheets, merge data seamlessly, secure files with enterprise-grade encryption, and extract insights through advanced row operations - all powered by cutting-edge PDF4me API technology

Unlock File

AI-generated

Summary

Remove various protections from an Excel file, including file encryption, workbook structure protection, and optionally worksheet content protection, producing an unlocked Excel file output.

Inputs

  • Excel File Input Method (required) — Select how to provide the Excel file: from previous node as binary, as a base64 string, or from a downloadable URL.
  • Binary Data Property Name (required) — Name of the binary property containing the Excel file when using binary input method.
  • Base64 Encoded Excel Content (required) — Base64 encoded string of the Excel file content when using base64 input method.
  • Excel File URL (required) — Publicly accessible URL to download the Excel file when using URL input method.
  • File Encryption Password — Password to remove file-level encryption if the Excel file is encrypted.
  • Workbook Protection Password — Password to remove workbook structure protection if applied.
  • Unlock Worksheets — Boolean flag to enable removal of worksheet-level content protection.
  • Worksheet Protection Password — Password to unlock protected worksheets, required if unlocking worksheets.
  • Worksheet Selection — Choice to unlock all worksheets, or specific ones by name or index when worksheet unlocking is enabled.
  • Worksheet Names — Comma-separated worksheet names to unlock, used if selecting worksheets by name.
  • Worksheet Indexes — Comma-separated worksheet indexes (1-based) to unlock, used if selecting worksheets by index.
  • Culture Name — Culture identifier for processing purposes (e.g., en-US).
  • Output File Name — Filename for the resulting unlocked Excel file.
  • Source Document Name — Original Excel file name for reference or processing.
  • Output Binary Data Name — Binary data property name for accessing the unlocked Excel file in the node output.

Output shape

a single binary data output containing the unlocked Excel file

The output binary property name is configurable; the output file will have protections removed as specified. Errors result in execution failure or error output if continue on fail is enabled.

Discussion