You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.
9 actions Leo can use in the apps and agents it builds for you: 5 that read Microsoft Excel data, 4 that create or update it.
Retrieves available options for the Folder ID field.
Retrieve rows from a specified table in an Excel worksheet.
Docs ↗Get the values of a specified Excel worksheet.
Docs ↗Get the values of the specified columns in an Excel worksheet.
Docs ↗Find a row by column and value in an Excel worksheet.
Docs ↗Update the properties of tablerow object. (Only for work or school account)
Update the value of a specific cell in an Excel worksheet.
Docs ↗Insert a new row into a specified Excel worksheet.
Docs ↗Adds rows to the end of specific table.
Docs ↗Leo connects Microsoft Excel to the ERP your business already runs on: the records it reads in Microsoft Excel land in your ERP, and what changes in the ERP flows back.
Authorize Microsoft Excel once, in a couple of clicks. Leo only gets the permissions you grant.
In plain language: the dashboard, portal or agent you want across Microsoft Excel and your ERP. No code, no mapping spreadsheets.
Leo builds it, you review, it goes live. Agents run on a schedule or on events, under the guardrails you set.
