Double-click the tFileInputExcel component to
open its Basic settings view.
In the File name/Stream field, browse to or
enter the path to the Excel file that contains the Account ID data to be
inserted. In this example, it is D:/AccountIdInput.xls. And the content of the file is as
- Select the All sheets check box to retrieve the data of the entire Excel file.
- In the Header field, enter 1 to skip one row in the beginning of the file.
Click the [...] button next to Edit schema and in the pop-up schema dialog box,
define the schema by adding three columns AccountId, LastName and
Name of String type.
Click OK to save the settings and close the dialog box.