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