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. Note: The value of the named field in the ExcelField column can be evaluated from a string containing a custom attribute, for example $\{MyExcelField\} or field$\{year\}$\{month\} or a schema XPath. For the latter, the XPath itself is parameterizable! Note: The name of the custom attribute in the ProcessValue column can be derived from a string containing another custom attribute, for example $\{MyCustomAttribute\} or customattribute$\{year\}$\{month\} or a schema XPath. For the latter, the XPath itself is parameterizable! Note: In the Read shape, the named field cannot be a range in the Excel document but only a cell.

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.

Note: The value of the named field in the ExcelField column can be evaluated from a string containing a custom attribute, for example $\{MyExcelField\} or field$\{year\}$\{month\} or a schema XPath. For the latter, the XPath itself is parameterizable!

Note: The name of the custom attribute in the ProcessValue column can be derived from a string containing another custom attribute, for example $\{MyCustomAttribute\} or customattribute$\{year\}$\{month\} or a schema XPath. For the latter, the XPath itself is parameterizable!

Note: In the Read shape, the named field cannot be a range in the Excel document but only a cell.

Common AgilePart Properties

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