SpreadSheet to Formulae
Use this action to retrieve all the formulae from a spreadsheet.
Using SpreadSheet to Formulae Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Click
, drag the
SpreadSheet to Formulae action under the
SpreadSheet utility to the canvas, place the pointer on the action, and then click
or double-click the action. The SpreadSheet to Formulae action window opens.
2. Edit the label name, if needed. By default, the label name is same as the action name.
3. In the Workbook Object field, enter the workbook object returned by spreadsheet read.
4. Click Done.
Output Schema
The SpreadSheet to Formulae action returns an output schema as shown in the figure that follows: