124 excelrest
Download as pptx, pdf0 likes10 views
The document outlines various Microsoft Graph API endpoints for managing Excel workbooks and their features, including read/write capabilities, data manipulation, and new features available through the beta endpoint. Additionally, it highlights functionalities such as conditional formatting, custom XML documents, and pivot table refresh. Users can provide feedback or ask questions through specified links.
124 excelrest
- 4. ? /v1.0/me/drive ? /v1.0/me/groups/{id}/drive ? /beta/sharePoint/sites/{site-id}/drives/{id}
- 5. ? Rich set of features o Read/write to Excel objects - worksheets, tables, range, charts, named items o Get chart as image o Sort and filter data o Call large set of worksheet functions o Perform calculation o Supports analysis mode (non persistent API mode) o Format table, chart, range. ? New features available through /beta endpoint o Pivot table refresh o Filtered range view (visible view) o New range functions (column/row before & after) GA version: https://graph.microsoft.com/v1.0/ Beta version: https://graph.microsoft.com/beta/
- 6. Named items – write operations Custom XML documents Data connection refresh Document properties Conditional formatting Copy to import worksheet Range as image Table – add multiple rows with single call Post your suggestions/questions: ? https://officespdev.uservoice.com/ ? Stackoverflow #microsoftgraph
- 8. Demo