Excel Read

This AgileShape can be used to read data from an Excel document and store the values in custom attributes to be used in the process.

The configuration is similar to that of WriteExcelDocument except there is no "Save To" field and there is a "Read" tab in Mappings, instead of a Write tab.

Properties for This AgilePart

Field Name	Definition
Configuration	Opens the Excel Read Configuration dialog box, where you can configure an Excel read action.
Mappings	For example, to read the value in the named field called ExcelResult into a custom attribute called ProcessResult, set the two mapping columns respectively. The Formatted check box, if set, indicates that the Formatted Value of the cell should be read instead of the Value. For example, a Currency type cell, would return €1,023.34 rather than 1023.34. This is useful for situations where Formatted values of numbers or dates are needed to be included in, say emails.

Field Name

Definition

Configuration

Opens the Excel Read Configuration dialog box, where you can configure an Excel read action.

Mappings

For example, to read the value in the named field called ExcelResult into a custom attribute called ProcessResult, set the two mapping columns respectively. The Formatted check box, if set, indicates that the Formatted Value of the cell should be read instead of the Value. For example, a Currency type cell, would return €1,023.34 rather than 1023.34. This is useful for situations where Formatted values of numbers or dates are needed to be included in, say emails.

Common AgilePart Properties

The properties of the basic AgilePart AgileShape are also included in this AgileShape. For more information, see AgilePart.