PDF4me ExcelInstall

Summary

Extract rows from an Excel file provided via binary data, base64 string, or URL, with options to specify worksheet, row/column ranges, header presence, and formatting preferences.

Inputs

• Excel File Input Method (required) — Select how to supply the Excel file: from a previous node's binary data, as a base64 encoded string, or by downloading from a URL.
• Binary Data Property Name (required) — Name of the binary property containing the Excel file (required if using binary data input method).
• Base64 Encoded Excel Content (required) — Base64 string of the Excel file (required if using base64 input method).
• Excel File URL (required) — Publicly accessible URL to download the Excel file (required if using URL input method).
• Worksheet Name — Specify worksheet name to extract from; defaults to first worksheet if empty.
• Has Header Row — Indicate if the first row contains column headers; defaults to true.
• First Row (Start) — Zero-based index of the first row to extract; defaults to 0.
• Last Row (End) — Zero-based index of the last row to extract; defaults to -1 to extract until last data row.
• First Column (Start) — Zero-based index of the first column to extract; defaults to 0.
• Last Column (End) — Zero-based index of the last column to extract; defaults to -1 to extract until last data column.
• Exclude Empty Rows — Skip rows completely empty; defaults to true.
• Exclude Hidden Rows — Skip hidden rows; defaults to true.
• Exclude Hidden Columns — Skip hidden columns; defaults to true.
• Export Values As Text — Export all cell values as text; defaults to false.
• Export Empty Cells — Include empty cells in output; defaults to false.
• Export as Object Structure — Export data as structured objects instead of arrays; defaults to false.
• Hyperlink Format — Choose to show hyperlink display text, URL, or both; defaults to 'Text'.
• Culture & Language Settings — Culture name for data formatting (e.g., en-US); defaults to 'en-US'.
• Source Document Name — Name of the original Excel file for reference; defaults to 'myExcelFile.xlsx'.

Output shape

A list of JSON objects representing the extracted rows and columns from the specified worksheet and range.

The output respects filtering options such as excluding empty, hidden rows/columns and formatting options. Data can be exported as arrays or objects depending on settings. Pagination is not indicated; errors during extraction may produce error envelopes if 'continueOnFail' is enabled.

Examples

Example 1: Extract rows from an Excel file passed as binary data, specifying worksheet and row range.

Set 'Excel File Input Method' to 'From Previous Node (Binary Data)' and provide binary property name; specify worksheet name and row/column indices to extract.

Example 2: Extract from a base64 input Excel file including all columns and rows.

Set input method to 'Base64 Encoded String', provide base64 content, and leave row/column range defaults to extract entire sheet.