workbook/worksheets('Sheet1')/charts('forecast')/image() For example, getting your ‘forecast’ chart is as simple as calling: Let’s take a look at the API – using the Microsoft Graph, you can address Excel workbooks sitting in OneDrive for Business or in any Office 365 group, for example:įrom there you can access the workbook, simply by adding the /workbook segment:Īs simple as that, you can then interact with the worksheets, ranges, tables, and charts in that workbook, and do filtering, sorting, call functions, apply formatting and much more. Today, we’re announcing the general availability of the Excel REST API which provides those same capabilities, and opens up a new world for Excel integrations – you can access, aggregate, analyze, model and generate data in Excel workbooks on Office 365 using simple HTTP calls. Last year, we announced a powerful Excel JavaScript API that enables developers to build interactive Office Add-ins. This addition to the Microsoft Graph is another step in our journey to enable modern programmability scenarios built on the Office platform. Excel, the beloved productivity tool, now has a powerful REST API as part of the Microsoft Graph that enables developers to build rich and deep integrations with Excel workbooks in Office 365.ĭo you need to calculate, analyze, automate, report on or manage data in your app? Well, look no further at building these capabilities yourself – using the new Excel REST API, you have the power and simplicity of Excel at your fingertips (or a few simple HTTP calls) for all of your app’s calculation needs.
0 kommentar(er)
