Using the OneCloud Excel BizApp provides native functions to create, read and manage Excel Workbooks. This ability opens up multiple use cases including:
Dynamically create an Excel Workbook from one or more tabular data sources.
Read from individual Excel Worksheets and generate a tabular output that can be used for downstream integrations.
Define a specific cell range to read from enabling content to be automatically extracted from Excel.
For documentation on all available commands, see the Microsoft Excel Command Reference.
To enable OneCloud to perform various operations with an Excel Workbook, you will need to navigate to the connection manager to create a connection. From here, choose Microsoft Excel from the service drop-down and select the appropriate Runner.
The following is an example of a working connection. Please substitute your own values.