The ExcelInput2 component reads the specified ExcelBuilder defined content from the input Excel formatted binary data, and writes the data to the output stream's records.
To use this component, it is necessary to open the ExcelBuilder, specify the Excel template file to read, define the work book cells from which the data is to be read and the ASTERIA fields to which this data is to be written.
Compared to Excel(Input) component, this component runs faster but readable workbooks are limited.
| Input | Format | Binary |
|---|---|---|
| Number of Inputs | 1 | |
| Description | The Excel file binary image. | |
| Output | Format | Record |
| Description |
The ExcelBuilder defined Excel data. Fields are defined in the ExcelBuilder, not FlowBuilder. |
| Name | Data Type/Selection | Mapping | Description | |
|---|---|---|---|---|
| Cell | category | Output Only |
The Excel cell as defined by the ExcelBuilder. When a flow is executed, the retrieved cell data is saved to this property. Fields are defined in the ExcelBuilder, not ASTERIA Designer. |
|
| InputSheetName | string | Yes |
If defined, the ExcelBuilder defined cells and records are pulled from this work sheet. This property can be defined in a preceding Mapper component. |
|
| IgnoreBlankRow | boolean | Yes |
If True, empty records are ignored. If False, empty records are read, and the respective fields are set as empty. If this component is in the loop, only the value specified for the first time is effective. |
|
| LoopProcess | boolean | None |
If True and the ExcelBuilder defined record area results in multiple matches, each record is output as an individual stream. If False, all resulting data is output as a single stream. |
|
If LoopProcess=True and the ExcelBuilder defined record area results in multiple matches, each record is output as an individual stream, thus creating a loop.
| Commit |
Do Nothing |
|---|---|
| Rollback |
Do Nothing |
| Type | Parameters | Flow Input Stream | Error Code | Cause |
|---|---|---|---|---|
| Exception | none |
This component's input stream. | none | Cannot read the ExcelBuilder defined cells. |
| none | Error converting data to the flow field data type. | |||
| none | Opening an Excel file of an unsupported format. Excel files formatted prior to Excel 95 are not supported. They must be saved as an Excel95 or later formatted file. |
This component can read Excel formatted files since Excel95. However, this component does not support the reading of Excel files formatted prior to Excel 95.
This component supports the reading of files up to 30MB in size.
The amount of data that can be input decreases as the number of cells increases. This occurs because the Excel format stores an additional 10 to 20 bytes of cell formatting data for each cell.
Category Maximum Cell Limit Number 1,800,000 cells Text 1,200,000 cells of 4 bytes 300,000 cells of 80 bytes 3600 cells of 8K