microsoft-excel

You can read and modify Excel workbooks in OneDrive by using the Microsoft Graph API to access worksheets, ranges, and tables. This requires managed OAuth access to authorize operations on user files.

Automate extracting table rows from an Excel spreadsheet by creating persistent workbook sessions via the Graph API. These sessions enable efficient multi-step operations like data extraction, transformation, and writing aggregated results to a new worksheet.

Yes, accessing Excel files in SharePoint requires a valid MATON_API_KEY for Maton gateway authentication. You also need optional Maton connection IDs to manage per-account OAuth sessions for secure access.

Handle Microsoft Graph API rate limits and common errors during batch updates by utilizing the Skill's session and error management features. Creating persistent workbook sessions helps manage efficient multi-step operations while mitigating API constraints.

The best way to manage OAuth connections for Microsoft Excel files is using a managed gateway to create, list, and manage connections. This removes the need to implement direct OAuth flows while enabling secure read and write operations.