PDF4me ExcelInstall

Summary

Extract specific worksheets from an Excel file by providing the file as binary data, a Base64 string, or a URL, and selecting worksheets to keep by name or by index.

Inputs

• Excel File Input Method (required) — Choose how to provide the Excel file for processing: from previous node as binary data, base64 encoded string, or download from URL.
• Binary Data Property Name (required) — When using binary data input method, specify the binary property containing the Excel file (default 'data').
• Base64 Encoded Excel Content (required) — When providing input as base64, enter the base64-encoded string of the Excel file content.
• Excel File URL (required) — When providing input as URL, specify the publicly accessible URL to download the Excel file.
• Extract By (required) — Choose whether to extract worksheets by their names or by their index positions (1-based).
• Worksheet Names — Comma-separated list of worksheet names to extract (only when extracting by name).
• Worksheet Indexes — Comma-separated list of worksheet indexes (1-based) to extract (only when extracting by index).
• Output File Name — File name for the output Excel file containing only the extracted worksheets.
• Source Document Name — Name for the original source Excel file for reference and processing.
• Output Binary Data Name — Name of the binary data property in the node's output containing the processed Excel file.

Output shape

a single binary file containing an Excel document with only the specified worksheets extracted

Output contains one binary data property (default name 'data'), holding the modified Excel file retaining only the selected worksheets. Input file can be provided in three ways but output is always a binary Excel file. Errors are thrown if extraction parameters are invalid.