The Excel(Input) 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.
| 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 97, such as Excel95 or older versions, must be saved as an Excel97 formatted file to be used by this component. |
This component can read Excel formatted files since Excel97. However, this component does not support the reading of Excel files formatted prior to Excel 97, such as Excel95 or older.
This component supports the reading of files up to 10MB in size. A single cell can contain up to 8K of data (4096 full length characters).
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 600,000 cells Text 400,000 cells of 4 bytes (2 full length characters) 100,000 cells of 80 bytes (40 full length characters) 1200 cells of 8K (4096 full length characters)