ExcelInput2

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.

Stream Information

InputFormatBinary
Number of Inputs1
DescriptionThe Excel file binary image.
OutputFormatRecord
Description

The ExcelBuilder defined Excel data.

Fields are defined in the ExcelBuilder, not FlowBuilder.

Component Properties

NameData Type/SelectionMappingDescription
CellcategoryOutput 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.

InputSheetNamestringYes

If defined, the ExcelBuilder defined cells and records are pulled from this work sheet. This property can be defined in a preceding Mapper component.

IgnoreBlankRowbooleanYes

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.

LoopProcessbooleanNone

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.

Loop Management

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.

Transaction Management

Commit

Do Nothing

Rollback

Do Nothing

Exceptions

TypeParametersFlow Input StreamError CodeCause
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.

Limitations

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.

CategoryMaximum Cell Limit
Number1,800,000 cells
Text1,200,000 cells of 4 bytes
300,000 cells of 80 bytes
3600 cells of 8K
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.