Excel REST API (Public preview)

on YouTube ↗06m

" summary

Public preview of Excel REST APIs lives on Microsoft Graph and targets Excel files in OneDrive for Business or SharePoint Online, addressed by adding "/workbook" URL segment to the Files API. APIs operate on worksheets, tables, ranges, charts and named items and support creation and management, read/update of range data and formulas, formatting, and download chart as image. Authentication uses OAuth2, transport is REST/OData with JSON. Demo shows a web app adding a row that updates the workbook and a Fiddler POST creating "Sheet3" that returns 201 Created response.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 0:17Overview
3. 0:31Excel REST API
4. 0:58Files API
5. 1:42Functionality
6. 2:36Initial steps
7. 3:01Demo
8. 5:58Conclusion

" related talks

• 58mThe Future of Calling Microsoft APIsSimon Jäger · NDC Oslo 2017
• 36mPowering Your Applications with Microsoft GraphNikola Metulev · Samsung Developer Conference 2019
• 51mPower BI and Web API's - not so low code ?Erik Svensen · SQLBits 2023
• 45mTurn Your Google Spreadsheets into a Web APIManuel BOILLOD · DevFest Nantes 2014
• 44mWeb APIs You Should Be Using in 2026: Unlocking Next-Level Web ExperiencesNhlanhla Lucky Nkosi · NDC Copenhagen 2026
• 24mJavaScript, spreadsheets and APITomasz Stachewicz · ConfrontJS 2022
• 39mNews from around Graph Q&ADarrel Miller, Olivia Shea, Jeremy Thake, Tim Fish, Jenn Cockrell, Jeremy Kelley, Matt Krause, Sebastien Levert, Kyle Marsh, Luberth Morera, Maisa Rissi, Patrick Rodgers, Brian T. Jackett · Microsoft Build 2023
• 23mCreate professional diagrams anytime, anywhere, with anyoneTripteesh Kaur, Fredric Morgan · Microsoft Ignite 2021