Excel Write

This AgileShape can be used to create and afterwards modify an Excel document based on an Excel template. The resultant document can be saved either to a SharePoint document library or to a directory path (local on the server or a shared folder).

Properties for This AgilePart

Field Name	Definition
Configuration	Opens the Excel Write Configuration dialog box, where you can configure an Excel write action.
Mappings	In order to update the named fields in the Excel sheet, they need to be mapped to the process values here. The named fields appear in the list box on the right and can be mapped to, by selecting them first and then pressing the arrow button. Once a named field is in the mapping grid on the left, in order to map it to a process value, first select the row and then press the ellipsis button to select from the schema dialog for the process or type a custom attribute directly in the ProcessValue column. If the file in Design-time Template changes, then it is necessary to press the Refresh button to reload the named fields again. 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: You can also use advance XPath expressions such as filtering. For example (XPATH)/my:myFields/my:field2[.>32] returns all items that match the filter (field2 > 32). In addition, you can combine XPath expressions and custom attributes like this: (XPATH)/my:myFields/my:field2[.>$\{myCustomAttribute\}] Note: If you have an XPath expression that returns more than one value, there is a feature for mapping them with a named field that is defined as a one-dimensional range in the Excel document. The AgilePart will fill the range with returned values from the XPath expression, but if the range does not contain enough cells for the number of values, it will not fill past the range of cells (in order to protect rest of the worksheet) and the remaining values will be simply discarded.

Field Name

Definition

Configuration

Opens the Excel Write Configuration dialog box, where you can configure an Excel write action.

Mappings

In order to update the named fields in the Excel sheet, they need to be mapped to the process values here.

The named fields appear in the list box on the right and can be mapped to, by selecting them first and then pressing the arrow button.

Once a named field is in the mapping grid on the left, in order to map it to a process value, first select the row and then press the ellipsis button to select from the schema dialog for the process or type a custom attribute directly in the ProcessValue column.

If the file in Design-time Template changes, then it is necessary to press the Refresh button to reload the named fields again.

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: You can also use advance XPath expressions such as filtering. For example (XPATH)/my:myFields/my:field2[.>32] returns all items that match the filter (field2 > 32). In addition, you can combine XPath expressions and custom attributes like this: (XPATH)/my:myFields/my:field2[.>$\{myCustomAttribute\}]

Note: If you have an XPath expression that returns more than one value, there is a feature for mapping them with a named field that is defined as a one-dimensional range in the Excel document. The AgilePart will fill the range with returned values from the XPath expression, but if the range does not contain enough cells for the number of values, it will not fill past the range of cells (in order to protect rest of the worksheet) and the remaining values will be simply discarded.

Common AgilePart Properties

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