Overview
This node processes Excel files provided as binary data and currently supports the operation to list all visible sheet names within an Excel workbook. It is useful when you want to inspect or dynamically handle the structure of Excel files in your workflow, such as extracting sheet names before deciding which sheets to process further.
A practical example: You receive an Excel file as input and want to get a list of all its sheet names to present options for downstream processing or filtering.
Properties
Name | Meaning |
---|---|
Binary Property Name | The name of the binary property that contains the Excel file data (default: "data"). |
Output
The node outputs JSON data with a single field:
sheetNames
: An array of strings representing the names of all visible sheets in the Excel file.
Example output JSON:
{
"sheetNames": ["Sheet1", "Sheet2", "Summary"]
}
No binary data is output by this node.
Dependencies
- Requires the Excel file to be provided as base64-encoded binary data under the specified binary property.
- Uses the
xlsx
library internally to parse Excel files. - No external API keys or services are required.
Troubleshooting
Error: Binary property "X" not found.
This error occurs if the specified binary property does not exist on the input item. Ensure that the binary property name matches exactly the property containing the Excel file data.Invalid or corrupted Excel file.
If the input binary data is not a valid Excel file, the node may fail to parse it. Verify that the input file is a proper Excel format and correctly encoded.Empty sheetNames array.
This can happen if the Excel file has no visible sheets or all sheets are hidden. Confirm the Excel file's content.