Excel Calculate

An AgilePart that allows both writing (temporarily or permanently) and reading from an Excel document in the same step.

Good to Know

The write operation happens first, and then the read operation occurs.

Write is carried out first and then Read in executed.

How to Start

In AgilePoint Envision, open a process template.
Navigate to the SharePoint stencil.
On the SharePoint stencil, drag the Excel Calculate AgileShape, and drop it on the process template.
To view the full list of properties, in the Design Tasks pane, click Show Properties.

Properties for This AgileShape

Field Name	Definition
Configuration	Opens the Following Window: Excel Services Configuration Window Purpose of this Window: Sets up an Excel operation.

Common AgilePart Properties

This AgilePart inherits the following common properties. For more information, see AgilePart - Common Setup. Note that only the relevant properties are available in AgilePoint Envision. Unneeded properties are hidden.

Name, (UID), Description, Debug, Audit Level, SessionMode, Wait All Incoming, AssemblyName, ClassName, Method, Optimizing, Activity Entry Message (Email), Task Completed Message (Email), ConfigureAttachments, Reference URL, ExceptionHandlerScope, SaveErrorMessageTo, SaveStatusTo, Retries, HandleException

BPMN Properties

Each AgileShape includes a set of BPMN properties. For more information, refer to Adding or Modifying BPMN Properties for an AgileShape.