Microsoft Excel 365
Manages Excel workbooks stored in OneDrive and SharePoint via Microsoft Graph API. Supports opening, creating, listing, and closing workbooks; managing worksheets (list, create, delete); reading and writing cell ranges and individual cells in DataTable format; row operations (get, set, append, insert, delete); column operations (get, insert, delete); structured table operations (list, create, get rows, add row, set row); formula read/write; hyperlink extraction; and clearing ranges or entire sheets. All operations require opening a workbook first to obtain a workbook ID. Authenticates via Azure AD client credentials (service account) or OAuth2 delegated flow.
| Namespace | Robomotion.Excel365 |
| Version | 1.1.0 |
| Category | Productivity, Business Software |
| Nodes | 31 |
Nodes
| Node | Description |
|---|---|
| Open Workbook | Opens a workbook in Microsoft Excel 365. |
| Close Workbook | Closes a workbook in Microsoft Excel 365. |
| Create Workbook | Creates a workbook in Microsoft Excel 365. |
| List Workbooks | Lists workbooks in Microsoft Excel 365. |
| Get Workbook | Gets a workbook in Microsoft Excel 365. |
| List Worksheets | Lists worksheets in Microsoft Excel 365. |
| Create Worksheet | Creates a worksheet in Microsoft Excel 365. |
| Delete Worksheet | Deletes a worksheet in Microsoft Excel 365. |
| List Tables | Lists tables in Microsoft Excel 365. |
| Create Table | Creates a table in Microsoft Excel 365. |
| Get Table Rows | Gets table rows in Microsoft Excel 365. |
| Get Table Row | Gets a table row in Microsoft Excel 365. |
| Set Table Row | Sets a table row in Microsoft Excel 365. |
| Append Table Row | Appends a table row in Microsoft Excel 365. |
| Read Range | Reads a range in Microsoft Excel 365. |
| Write Range | Writes a range in Microsoft Excel 365. |
| Get Cell | Gets a cell in Microsoft Excel 365. |
| Set Cell | Sets a cell in Microsoft Excel 365. |
| Get Row | Gets a row in Microsoft Excel 365. |
| Set Row | Sets a row in Microsoft Excel 365. |
| Append Row | Appends a row in Microsoft Excel 365. |
| Delete Row | Deletes a row in Microsoft Excel 365. |
| Get Column | Gets a column in Microsoft Excel 365. |
| Insert Column | Inserts a column in Microsoft Excel 365. |
| Delete Column | Deletes a column in Microsoft Excel 365. |
| Clear Range | Clear Range — see the properties below. |
| Clear Sheet | Clear Sheet — see the properties below. |
| Get Formula | Gets a formula in Microsoft Excel 365. |
| Set Formula | Sets a formula in Microsoft Excel 365. |
| Get Hyperlink | Gets a hyperlink in Microsoft Excel 365. |
| Toolkit | Exposes this package's operations to an AI Agent as a single tool. |
AI Agent tools
30 of these nodes are exposed as tools an AI Agent can call directly:
Open Workbook, Close Workbook, Create Workbook, List Workbooks, Get Workbook, List Worksheets, Create Worksheet, Delete Worksheet, List Tables, Create Table, Get Table Rows, Get Table Row, Set Table Row, Append Table Row, Read Range, Write Range, Get Cell, Set Cell, Get Row, Set Row, Append Row, Delete Row, Get Column, Insert Column, Delete Column, Clear Range, Clear Sheet, Get Formula, Set Formula, Get Hyperlink.
Generated from the package spec that the Flow Designer itself loads, so the node list and every property below match the version above exactly.
It does not yet include worked examples or service-specific guidance — those are written by hand, and a plausible-sounding guess in a reference page is worse than an honest gap. If you build something useful with this package, the community is the place to share it.