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
-
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.
