Reflects the current release of Nintex for SharePoint 2016. For your version, please access assistance through the Help button in the product.
Enterprise Edition for Nintex Workflow 2016 is required for this feature.
Retrieves data from a Microsoft Excel workbook via Excel Services.
Note: Office Online Server with legacy components enabled is required for this feature.
To enable legacy components, first configure Office Online Server and then run the following script on a SharePoint server using SharePoint 2016 Management Shell.
$Farm = Get-SPFarm
$Farm.Properties.Add("WopiLegacySoapSupport", "http://OOSServer/x/_vti_bin/ExcelServiceInternal.asmx")
$Farm.Update()
Where http://OOSServer is the URL to Office Online Server in your environment.
URL to the excel services web service.
Example:
Web_URL/_vti_bin/ExcelService.asmx
(where Web_URL is a variable)
Providing this URL is optional. If the URL is left blank, this action will use the default excel services URL based on the URL of the site workflow is running on.
Username and password: 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.