Configuring the input component - tFileInputExcel - Cloud - 8.0

Excel
Version
Cloud
8.0
Language
English (United States)
Product
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
Module
Talend Studio
Content
Data Governance > Third-party systems > File components (Integration) > Excel components
Data Quality and Preparation > Third-party systems > File components (Integration) > Excel components
Design and Development > Third-party systems > File components (Integration) > Excel components

Before you begin

For this example, you must have an Excel file you will use in the Job, as follows.

In this example, you will extract data from cells A4, B2, C9 and D6.

Procedure

  1. Double-click the tFileInputExcel component to open its Basic settings view.
  2. Click the [...] button next to the File Name/Stream field and browse to the source file, in this example example__extract_specific_cells.xlsx.
  3. In Sheet list, click the [+] button and enter the name of the Excel sheet to be processed between double quotation marks, in this example Sheet1.
  4. In the Header field, enter the number of rows to be skipped in the beginning of file, in this example 1.
  5. Click the [...] button next to Edit Schema to define the schema of the input file.

    In this example, the source file holds four columns: lastname, firstname, city and zip.

  6. Click OK to validate your changes and close the dialog box.