Takes excel (.xlsx) files as input and fetches the required data from the file.
Configuration
Figure 1: Component Property Sheet
Error Handling Configuration
The actions to be taken when a particular error occurs can be configured using this attribute.
Click the ellipsis button against this property to configure Error Handling properties for different types of Errors. By default, the actions Log to error logs, Stop service and Send to error port are enabled.
Response Size
Input the number of records to be aggregated in the response.
Data Index
The row from which the actual data starts.
Header Data Row
The row number where the Header data is present. This row will have the Column names.
Headers
Mention the names of the headers that are to be filtered.
Multiple values (Header names) must be separated by commas, where each value (Header name) must be provided without space.
Figure 2: Comma-separated values without space
Functional Demonstration
Scenario
Configure the ExcelReader microservice as shown in Figure 1. Select the input file using the Feeder microservice as shown in the sample input below and display the output using the Display microservice.
Figure 3: Sample Event Process
Sample Input
Go to the Message Details Configuration panel in the Feeder microservice and add the following values:
- Directory: Path of the excel file.
- FileName: Name of the excel file along with the extension (.xlsx).
Figure 4: Directory path and excel filename provided in the Feeder - Message Details Configuration panel
Sample Output
The data extracted from the excel file will be displayed in the Display microservice.
Figure 5: Output of the excel file displayed in the Display window