-
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
follows:
-
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.
Click OK to save the settings and close the dialog box.