Microsoft Excel
ProductivityOAuth 2.0
Read and write worksheets, ranges and tables of Excel workbooks stored in OneDrive or SharePoint.
8 actions
| Action | Effect | Data handled | Scope |
|---|---|---|---|
| microsoft_excel_list_worksheetsLists the worksheets of an Excel workbook stored in OneDrive or SharePoint | read | General | Files.Read |
| microsoft_excel_add_worksheetAdds a worksheet to an Excel workbook | write | General | Files.ReadWrite |
| microsoft_excel_get_rangeReads the cell values of a range in an Excel worksheet | read | Personal data | Files.Read |
| microsoft_excel_update_rangeWrites values or formulas into a range of an Excel worksheet | write | Personal data | Files.ReadWrite |
| microsoft_excel_get_used_rangeReads every cell in use on an Excel worksheet, the smallest range holding all its data | read | Personal data | Files.Read |
| microsoft_excel_list_tablesLists the tables in an Excel workbook, with their names and worksheets | read | General | Files.Read |
| microsoft_excel_list_table_rowsReads the rows of an Excel table | read | Personal data | Files.Read |
| microsoft_excel_add_table_rowsAdds rows to the end of an Excel table, or at a position | write | Personal data | Files.ReadWrite |