Microsoft Excel
Documents & Storage
Tool for spreadsheets
finance
Actions
Get item by name
Searches for Excel files by name across OneDrive and SharePoint sites, returning their ID, driveId, name, URL, and metadata
Get workbook summary
Retrieves a summary of an Excel workbook including all sheets, their data ranges, tables, and charts
Get range
Retrieves data from a specified cell range in a worksheet
Update cells
Updates cells in a worksheet at a specified range
Add table row
Adds a new row to the end of a table
Excel Get table rows
Retrieves rows from a table with pagination support
Insert formulas
Inserts Excel formulas into cells at a specified range
Create issue
Creates an issue for a specified repository
Create spreadsheet
Creates a new Excel spreadsheet
Update cell values
Updates values in selected cells
Append rows
Adds new rows to a worksheet
Generate summary
Generates a summary from spreadsheet data
Read worksheet data
Retrieves data from an Excel worksheet