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.
Restriction: The tBRMS component supports the
XLSX format from version 8.0 R2022-09. If you are
using a previous version, do not select Read excel2007 file
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
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.