Procedure
-
Double-click tFileInputExcel to open its Basic
settings view and define the component properties:
- In the Property type list, select Built-in and fill in the fields that follow.
-
Click the [...] button next to the File Name/Stream field and
browse to the source file to set its path and name. The source file used in this
example is called brmsInput and it holds
candidate data.
Note: As tBRMS does not support the .xlsx format, do not select Read excel2007 file format(xlsx).
- If needed, right-click tFileInputExcel and select Data viewer to have a preview of the input data.
- Select the All sheets check box to retrieve the data from all sheets of the excel file.
-
From the Schema list, select Built-in and click Edit
schema to define the structure of the source data. In this
example, five columns are defined for the input information of candidates.
- Click OK to validate your changes and close the dialog box.