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.