Excel(Input)

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.

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 97, such as Excel95 or older versions, must be saved as an Excel97 formatted file to be used by this component.

Limitations

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).

CategoryMaximum Cell Limit
Number600,000 cells
Text400,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)
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.