excel_operations
Read, write, and apply formulas to Excel workbooks stored in OneDrive or SharePoint. Supports operations like reading ranges, writing data, adding worksheets, creating tables, and generating charts.
Instructions
Perform operations on Excel workbooks (read, write, formulas)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| itemId | No | Excel file item ID | |
| itemPath | No | Alternative: Excel file path | |
| siteId | No | SharePoint site ID (optional) | |
| site | No | Known SharePoint site alias or canonical URL | |
| siteUrl | No | Canonical SharePoint site URL (optional alternative to siteId) | |
| driveId | No | Drive ID for a specific document library (optional) | |
| operation | Yes | Operation to perform | |
| worksheet | No | Worksheet name | Sheet1 |
| range | No | Cell range (e.g., "A1:C10") | |
| values | No | Values to write (2D array of cell values) | |
| formulas | No | Formulas to set (2D array of formula strings) | |
| tableName | No | Name for new table | |
| hasHeaders | No | Whether table has headers | |
| chartType | No | Chart type to create | |
| useSession | No | Use persistent session for better performance |