How to extract data from specific Excel cells - 7.3

How to extract data from specific Excel cells

author
Shicong Hong
EnrichVersion
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
task
Design and Development > Designing Jobs
EnrichPlatform
Talend Studio
This article explains how to extract data from specific Excel cells.
In this example:
  • The tFileInputExcel component reads an Excel file and extracts data.
  • The tFixedFlowInput component generates one input flow including the data of the specific cells, using the context variables.
  • The tJavaRow component allows you to enter customized code.
  • The tLogRow component displays data in the Run console.