Excel Reader
The Excel Reader component allows you to retrieve data (migration content) from an Excel sheet within an Excel document.
Excel documents can consist of multiple sheets, by default it will retrieve all non-empty cells from the first sheet of the document.
When configuring the sheet name, you can choose any other sheet from the document.
The component will start reading when it receives a message and outputs by row or the full sheet, depending on the configuration. The local file system or a cloud storage can be used. In order to access the local filesystem, the XILL4_WORKDIRS
environment variable must be set to the path of the directory to be accessed.
The format of the saved data is:
"Sheet1": {
"1": {
"1": "Source category",
"2": "Target category",
"3": "Permissions"
},
}
The first object represents the worksheet, the second a row and the inner-most keys are the cells.
Configuration
Inputs | Outputs
Any message will make the component start reading the file from the path that is given in the configuration. However, the path can be overwritten by sending {path: "/path/to/file.xlsx"}
to the input.