Read File
AI-generatedOverview
This node operation reads an XLSX file from a specified file path and outputs its content. It is useful for workflows that need to access and process data stored in Excel files. For example, it can be used to import data from an Excel spreadsheet into a workflow for further processing or analysis.
Use Case Examples
- Reading an Excel file to extract data for reporting.
- Importing user data from an XLSX file into a CRM system.
Properties
| Name | Meaning |
|---|---|
| File (.xlsx) | Path to the XLSX file. If the path is not absolute, it is considered relative to /data/sheet-manager. Defaults to /tmp/data.xlsx. |
Output
Binary
Outputs the XLSX file content as a binary file with MIME type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.
JSON
success- Indicates whether the file was successfully read (true or false).message- Provides a message about the operation, such as an error if the file does not exist.
Dependencies
- Uses the 'exceljs' library to handle XLSX files.
- Requires access to the file system to read files from specified paths.
Troubleshooting
- If the file does not exist at the specified path, the node outputs a failure message indicating the file is missing.
- Ensure the file path is correct and accessible by the workflow environment.
- Permissions issues on the file or directory may prevent reading the file, resulting in errors.