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, B1, C9 and D6.
Double-click the tFileInputExcel component to open its
Basic settings view.
- Click the [...] button next to the File Name/Stream field and browse to the source file, in this example example__extract_specific_cells.xlsx.
- 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.
- In the Header field, enter the number of rows to be skipped in the beginning of file, in this example 1.
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.
- Click OK to validate your changes and close the dialog box.