Spreadsheet
SpreadSheet Reader
Use this action to read the spreadsheet (xlsx file) from your local file storage system.
Using SpreadSheet Reader 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 Reader action under the SpreadSheet utility to the canvas, place the pointer on the action, and then click or double-click the action. The SpreadSheet Reader action window opens.
2. Edit the Label name, if needed. By default, the label name is same as the action name.
3. To add the SpreadSheet Reader, in the SpreadSheet File Path field, enter the path of the xlsx file saved on your local storage.
4. Click Done.
Output Schema
The SpreadSheet Reader action returns an output schema as shown in the figure that follows: