* This topic applies to Nintex Workflow Enterprise Edition only
* This action requires Microsoft SharePoint Server
This workflow action will retrieve data from a Microsoft Excel workbook via Excel Services.
To use the workflow action:
Alternatively
To change the settings used by the action:
For more information on the other options in the drop-down, please refer to the Getting started with the Nintex Workflow designer.
Valid credentials to access the Excel Services web service. The credentials must have access to the workbook.
The location of the Excel workbook to query. The workbook must be in a configured Excel Service trusted location.
The name of the Excel sheet in the workbook that will be queried.
Specifies cells that should be set in the workbook before data is retrieved. Changes to these cell values are not committed to the workbook, they are only used to determine the values of the cells to retrieve information.
For example, if the cell to retrieve is the sum of E2 and E4, E2 and E4 can be set in this section and the result will be reflected in the cell to retrieve that data. Multiple cells can be updated by clicking the Add cell to update link.
The range of cells to retrieve values from. A single cell must be specified in the 'A1' format. Cell ranges must be specified in the 'A1:B2' format. If a cell or cell range is named, the defined name can also be specified.
The workflow variable to store the resulting value in.
If the selected variable can only contain a single value and a range is returned, only the first cell in the range will be used.
In a collection, values are stored left to right, top to bottom. For example, if the range to return is A1:B3, the values will be stored in this order: A1, A2, A3, B1, B2, B3.
Specifies whether or not to keep the cell formatting, or only return the plain value. For example, if a cell is formatted to display numbers as currency, selecting this option will return a string with the currency symbol matching the display in Excel. If this option is not selected, only the numeric value of the cell is stored.