Overview

This node operation allows users to view the contents of a specific sheet within an XLSX file. It reads the specified Excel file and extracts the data from the named sheet, returning the sheet data as JSON along with the file in binary format. This is useful for workflows that need to inspect or process data from existing Excel sheets without modifying them.

Use Case Examples

1. A user wants to read and display the data from a sales report stored in an Excel file within an automated workflow.
2. A workflow needs to extract data from a specific sheet in an Excel file to use it for further processing or integration with other systems.

Properties

Output

Binary

The node outputs the Excel file as binary data encoded in base64, including the MIME type and file name, allowing downstream nodes to access the original file.

JSON

• data - Array of objects representing the rows of the sheet, where each object maps column headers to cell values.

Dependencies

• Uses the 'exceljs' library to read and manipulate XLSX files.
• Requires access to the file system to read the Excel files from specified paths.

Troubleshooting

• If the specified file does not exist, the node throws an error indicating the file is missing.
• If the specified sheet name does not exist in the file, the node throws an error indicating the sheet is missing.
• Ensure the file path is correct and accessible by the workflow environment.
• Verify the sheet name matches exactly, including case sensitivity.