Sometimes you will need to extract data from specific Excel cells rather than all of the data in the file. This article explains how to extract data from specific cells.
This procedure was written with:
Talend verified this procedure to be compatible with:
Use an Excel file, as follows
This example will extract data from cells D4 and B7.
Create a Job called ExtractSpecificCellDemo. The detailed component settings are as follows:
The tJavaRow code:
context.d4 = input_row.c4;
context.b7 = input_row.c2;
In this Job two context variables are defined to store the data extracted from the specific cells.
Execute the Job. The following text is output to the console:
Starting Job ExtractSpecificCellDemo at 15:47 02
[statistics] connecting to socket on port 3733
Job ExtractSpecificCellDemo ended at 15:47 02