Microsoft Graph: Excel workbooks
Read and write Excel workbooks stored in OneDrive or SharePoint: worksheets, ranges, tables, charts, named items and calculations, with or without a session.…
Productivity & workspace#openapi
Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.
Overview
Read and write Excel workbooks stored in OneDrive or SharePoint: worksheets, ranges, tables, charts, named items and calculations, with or without a session.
This listing is one area of Microsoft Graph, the single REST API for Microsoft 365, Outlook, OneDrive, Teams and Microsoft Entra ID. It holds 400 of the area's requests, the most direct ones first, generated from Microsoft's own OpenAPI description of Graph v1.0. The other areas (mail, calendar, files, Teams, users and more) are listed separately on the Microsoft page.
Get an access token
- Sign in to the Microsoft Entra admin center and open App registrations > New registration. For a quick test, the Graph Explorer signs you in and shows a token without registering anything.
- Under API permissions, add the Microsoft Graph permissions this area needs, for example:
Files.ReadWrite. Delegated permissions act as the signed-in user; application permissions act as the app itself and need an administrator's consent. - Under Certificates & secrets, create a client secret (keep it out of shared collections).
- Get a token from
https://login.microsoftonline.com/ /oauth2/v2.0/token: the authorization-code flow for a user, orgrant_type=client_credentialswithscope=https://graph.microsoft.com/.defaultfor an app. Send it asAuthorization: Bearer.
Using these requests
- Base URL:
https://graph.microsoft.com/v1.0./me/...paths act on the signed-in user; with an application token use/users/{id or userPrincipalName}/...instead. - Shape responses with OData query parameters:
$select(fields),$filter,$orderby,$top,$expandand$search(some need theConsistencyLevel: eventualheader). Long lists are paged: follow@odata.nextLink. - Combine up to 20 requests in one call with
POST /$batch.
Common errors
| Status | Code | What to do |
|---|---|---|
| 401 | InvalidAuthenticationToken | The token is missing, expired or for another resource: get a new one for https://graph.microsoft.com. |
| 403 | Authorization_RequestDenied / ErrorAccessDenied | Add the permission listed in the request's docs and grant consent. |
| 404 | ResourceNotFound / itemNotFound | Check the id; ids from another user or tenant are not found. |
| 429 | TooManyRequests | Throttled: wait the Retry-After seconds, then retry. |
Docs: Excel workbooks overview · Permissions reference · Throttling
Endpoints 400
Drives: items
- GETGet workbook
/drives/:drive-id/items/:driveItem-id/workbookFor files that are Excel spreadsheets, access to the workbook API to work with the spreadsheet's contents. Nullable. - DELETEDelete workbook
/drives/:drive-id/items/:driveItem-id/workbook - PATCHUpdate workbook
/drives/:drive-id/items/:driveItem-id/workbook - GETList names
/drives/:drive-id/items/:driveItem-id/workbook/namesRepresents a collection of workbooks scoped named items (named ranges and constants). Read-only. - POSTCreate name
/drives/:drive-id/items/:driveItem-id/workbook/names - GETList tables
/drives/:drive-id/items/:driveItem-id/workbook/tablesRepresents a collection of tables associated with the workbook. Read-only. - POSTCreate table
/drives/:drive-id/items/:driveItem-id/workbook/tables - GETList comments
/drives/:drive-id/items/:driveItem-id/workbook/commentsRepresents a collection of comments in a workbook. - POSTCreate comment
/drives/:drive-id/items/:driveItem-id/workbook/comments - GETList functions
/drives/:drive-id/items/:driveItem-id/workbook/functions - DELETEDelete functions
/drives/:drive-id/items/:driveItem-id/workbook/functions - PATCHUpdate functions
/drives/:drive-id/items/:driveItem-id/workbook/functions - GETList operations
/drives/:drive-id/items/:driveItem-id/workbook/operationsThe status of workbook operations. Getting an operation collection is not supported, but you can get the status of a long-running operation if the Location… - POSTCreate operation
/drives/:drive-id/items/:driveItem-id/workbook/operations - GETList worksheets
/drives/:drive-id/items/:driveItem-id/workbook/worksheetsRepresents a collection of worksheets associated with the workbook. Read-only. - POSTCreate worksheet
/drives/:drive-id/items/:driveItem-id/workbook/worksheets - GETGet application
/drives/:drive-id/items/:driveItem-id/workbook/application - DELETEDelete application
/drives/:drive-id/items/:driveItem-id/workbook/application - PATCHUpdate application
/drives/:drive-id/items/:driveItem-id/workbook/application - POSTCreate close session
/drives/:drive-id/items/:driveItem-id/workbook/closeSessionUse this API to close an existing workbook session. - POSTCreate session (workbook)
/drives/:drive-id/items/:driveItem-id/workbook/createSessionCreate a new workbook session. Excel APIs can be called in one of two modes: To represent the session in the API, use the workbook-session-id: {session-id}… - POSTCreate refresh session
/drives/:drive-id/items/:driveItem-id/workbook/refreshSessionUse this API to refresh an existing workbook session. - GETGet workbook
/drives/:drive-id/items/:driveItem-id/workbook/sessionInfoResource(key=':key') - GETGet workbook
/drives/:drive-id/items/:driveItem-id/workbook/tableRowOperationResult(key=':key')This function is the last in a series of steps to create a workbookTableRow resource asynchronously. A best practice to create multiple table rows is to batch… - POSTAdd name
/drives/:drive-id/items/:driveItem-id/workbook/names/addAdds a new name to the collection of the given scope using the user's locale for the formula. - POSTAdd table
/drives/:drive-id/items/:driveItem-id/workbook/tables/addCreate a new table. The range source address determines the worksheet under which the table will be added. If the table can't be added (for example, because… - POSTCreate n
/drives/:drive-id/items/:driveItem-id/workbook/functions/n - POSTCreate t
/drives/:drive-id/items/:driveItem-id/workbook/functions/t - POSTCreate db
/drives/:drive-id/items/:driveItem-id/workbook/functions/db - POSTCreate fv
/drives/:drive-id/items/:driveItem-id/workbook/functions/fv - POSTCreate if
/drives/:drive-id/items/:driveItem-id/workbook/functions/if - POSTCreate ln
/drives/:drive-id/items/:driveItem-id/workbook/functions/ln - POSTCreate na
/drives/:drive-id/items/:driveItem-id/workbook/functions/na - POSTCreate or
/drives/:drive-id/items/:driveItem-id/workbook/functions/or - POSTCreate pi
/drives/:drive-id/items/:driveItem-id/workbook/functions/pi - POSTCreate pv
/drives/:drive-id/items/:driveItem-id/workbook/functions/pv - POSTCreate ab
/drives/:drive-id/items/:driveItem-id/workbook/functions/abs - POSTCreate and
/drives/:drive-id/items/:driveItem-id/workbook/functions/and - POSTCreate asc
/drives/:drive-id/items/:driveItem-id/workbook/functions/asc - POSTCreate co
/drives/:drive-id/items/:driveItem-id/workbook/functions/cos - POSTCreate cot
/drives/:drive-id/items/:driveItem-id/workbook/functions/cot - POSTCreate csc
/drives/:drive-id/items/:driveItem-id/workbook/functions/csc - POSTCreate day
/drives/:drive-id/items/:driveItem-id/workbook/functions/day - POSTCreate ddb
/drives/:drive-id/items/:driveItem-id/workbook/functions/ddb - POSTCreate erf
/drives/:drive-id/items/:driveItem-id/workbook/functions/erf - POSTCreate exp
/drives/:drive-id/items/:driveItem-id/workbook/functions/exp - POSTCreate gcd
/drives/:drive-id/items/:driveItem-id/workbook/functions/gcd - POSTCreate int
/drives/:drive-id/items/:driveItem-id/workbook/functions/int - POSTCreate irr
/drives/:drive-id/items/:driveItem-id/workbook/functions/irr - POSTCreate lcm
/drives/:drive-id/items/:driveItem-id/workbook/functions/lcm - POSTCreate len
/drives/:drive-id/items/:driveItem-id/workbook/functions/len - POSTCreate log
/drives/:drive-id/items/:driveItem-id/workbook/functions/log - POSTCreate max
/drives/:drive-id/items/:driveItem-id/workbook/functions/max - POSTCreate mid
/drives/:drive-id/items/:driveItem-id/workbook/functions/mid - POSTCreate min
/drives/:drive-id/items/:driveItem-id/workbook/functions/min - POSTCreate mod
/drives/:drive-id/items/:driveItem-id/workbook/functions/mod - POSTCreate not
/drives/:drive-id/items/:driveItem-id/workbook/functions/not - POSTCreate now
/drives/:drive-id/items/:driveItem-id/workbook/functions/now - POSTCreate npv
/drives/:drive-id/items/:driveItem-id/workbook/functions/npv - POSTCreate odd
/drives/:drive-id/items/:driveItem-id/workbook/functions/odd - POSTCreate phi
/drives/:drive-id/items/:driveItem-id/workbook/functions/phi - POSTCreate pmt
/drives/:drive-id/items/:driveItem-id/workbook/functions/pmt - POSTCreate rri
/drives/:drive-id/items/:driveItem-id/workbook/functions/rri - POSTCreate sec
/drives/:drive-id/items/:driveItem-id/workbook/functions/sec - POSTCreate sin
/drives/:drive-id/items/:driveItem-id/workbook/functions/sin - POSTCreate sln
/drives/:drive-id/items/:driveItem-id/workbook/functions/sln - POSTCreate sum
/drives/:drive-id/items/:driveItem-id/workbook/functions/sum - POSTCreate syd
/drives/:drive-id/items/:driveItem-id/workbook/functions/syd - POSTCreate tan
/drives/:drive-id/items/:driveItem-id/workbook/functions/tan - POSTCreate vdb
/drives/:drive-id/items/:driveItem-id/workbook/functions/vdb - POSTCreate xor
/drives/:drive-id/items/:driveItem-id/workbook/functions/xor - POSTCreate aco
/drives/:drive-id/items/:driveItem-id/workbook/functions/acos - POSTCreate acot
/drives/:drive-id/items/:driveItem-id/workbook/functions/acot - POSTCreate asin
/drives/:drive-id/items/:driveItem-id/workbook/functions/asin - POSTCreate atan
/drives/:drive-id/items/:driveItem-id/workbook/functions/atan - POSTCreate base
/drives/:drive-id/items/:driveItem-id/workbook/functions/base - POSTCreate char
/drives/:drive-id/items/:driveItem-id/workbook/functions/char - POSTCreate code
/drives/:drive-id/items/:driveItem-id/workbook/functions/code - POSTCreate cosh
/drives/:drive-id/items/:driveItem-id/workbook/functions/cosh - POSTCreate coth
/drives/:drive-id/items/:driveItem-id/workbook/functions/coth - POSTCreate csch
/drives/:drive-id/items/:driveItem-id/workbook/functions/csch - POSTCreate date
/drives/:drive-id/items/:driveItem-id/workbook/functions/date - POSTCreate day
/drives/:drive-id/items/:driveItem-id/workbook/functions/days - POSTCreate dbc
/drives/:drive-id/items/:driveItem-id/workbook/functions/dbcs - POSTCreate dget
/drives/:drive-id/items/:driveItem-id/workbook/functions/dget - POSTCreate disc
/drives/:drive-id/items/:driveItem-id/workbook/functions/disc - POSTCreate dmax
/drives/:drive-id/items/:driveItem-id/workbook/functions/dmax - POSTCreate dmin
/drives/:drive-id/items/:driveItem-id/workbook/functions/dmin - POSTCreate dsum
/drives/:drive-id/items/:driveItem-id/workbook/functions/dsum - POSTCreate dvar
/drives/:drive-id/items/:driveItem-id/workbook/functions/dvar - POSTCreate erf c
/drives/:drive-id/items/:driveItem-id/workbook/functions/erfC - POSTCreate even
/drives/:drive-id/items/:driveItem-id/workbook/functions/even - POSTCreate fact
/drives/:drive-id/items/:driveItem-id/workbook/functions/fact - POSTFind function
/drives/:drive-id/items/:driveItem-id/workbook/functions/find - POSTCreate hour
/drives/:drive-id/items/:driveItem-id/workbook/functions/hour - POSTCreate im ln
/drives/:drive-id/items/:driveItem-id/workbook/functions/imLn - POSTCreate ipmt
/drives/:drive-id/items/:driveItem-id/workbook/functions/ipmt - POSTCreate is n a
/drives/:drive-id/items/:driveItem-id/workbook/functions/isNA - POSTCreate kurt
/drives/:drive-id/items/:driveItem-id/workbook/functions/kurt - POSTCreate left
/drives/:drive-id/items/:driveItem-id/workbook/functions/left - POSTCreate lenb
/drives/:drive-id/items/:driveItem-id/workbook/functions/lenb - POSTCreate max a
/drives/:drive-id/items/:driveItem-id/workbook/functions/maxA - POSTCreate midb
/drives/:drive-id/items/:driveItem-id/workbook/functions/midb - POSTCreate min a
/drives/:drive-id/items/:driveItem-id/workbook/functions/minA - POSTCreate mirr
/drives/:drive-id/items/:driveItem-id/workbook/functions/mirr - POSTCreate nper
/drives/:drive-id/items/:driveItem-id/workbook/functions/nper - POSTCreate ppmt
/drives/:drive-id/items/:driveItem-id/workbook/functions/ppmt - POSTCreate rand
/drives/:drive-id/items/:driveItem-id/workbook/functions/rand - POSTCreate rate
/drives/:drive-id/items/:driveItem-id/workbook/functions/rate - POSTCreate rept
/drives/:drive-id/items/:driveItem-id/workbook/functions/rept - POSTCreate row
/drives/:drive-id/items/:driveItem-id/workbook/functions/rows - POSTCreate sech
/drives/:drive-id/items/:driveItem-id/workbook/functions/sech - POSTCreate sign
/drives/:drive-id/items/:driveItem-id/workbook/functions/sign - POSTCreate sinh
/drives/:drive-id/items/:driveItem-id/workbook/functions/sinh - POSTCreate skew
/drives/:drive-id/items/:driveItem-id/workbook/functions/skew - POSTCreate sqrt
/drives/:drive-id/items/:driveItem-id/workbook/functions/sqrt - POSTCreate tanh
/drives/:drive-id/items/:driveItem-id/workbook/functions/tanh - POSTCreate text
/drives/:drive-id/items/:driveItem-id/workbook/functions/text - POSTCreate time
/drives/:drive-id/items/:driveItem-id/workbook/functions/time - POSTCreate trim
/drives/:drive-id/items/:driveItem-id/workbook/functions/trim - POSTCreate true
/drives/:drive-id/items/:driveItem-id/workbook/functions/true - POSTCreate type
/drives/:drive-id/items/:driveItem-id/workbook/functions/type - POSTCreate var a
/drives/:drive-id/items/:driveItem-id/workbook/functions/varA - POSTCreate xirr
/drives/:drive-id/items/:driveItem-id/workbook/functions/xirr - POSTCreate xnpv
/drives/:drive-id/items/:driveItem-id/workbook/functions/xnpv - POSTCreate year
/drives/:drive-id/items/:driveItem-id/workbook/functions/year - GETCount table
/drives/:drive-id/items/:driveItem-id/workbook/tables/count() - POSTAdd worksheet
/drives/:drive-id/items/:driveItem-id/workbook/worksheets/addAdd a new worksheet to the workbook. The worksheet is added at the end of existing worksheets. If you want to activate the newly added worksheet, call… - POSTCreate acosh
/drives/:drive-id/items/:driveItem-id/workbook/functions/acosh - POSTCreate acoth
/drives/:drive-id/items/:driveItem-id/workbook/functions/acoth - POSTCreate area
/drives/:drive-id/items/:driveItem-id/workbook/functions/areas - POSTCreate asinh
/drives/:drive-id/items/:driveItem-id/workbook/functions/asinh - POSTCreate atan2
/drives/:drive-id/items/:driveItem-id/workbook/functions/atan2 - POSTCreate atanh
/drives/:drive-id/items/:driveItem-id/workbook/functions/atanh - POSTCreate bitor
/drives/:drive-id/items/:driveItem-id/workbook/functions/bitor - POSTCreate clean
/drives/:drive-id/items/:driveItem-id/workbook/functions/clean - POSTCreate count
/drives/:drive-id/items/:driveItem-id/workbook/functions/count - POSTTrack changes to functions (delta)
/drives/:drive-id/items/:driveItem-id/workbook/functions/delta - POSTCreate dev sq
/drives/:drive-id/items/:driveItem-id/workbook/functions/devSq - POSTCreate dvar p
/drives/:drive-id/items/:driveItem-id/workbook/functions/dvarP - POSTCreate edate
/drives/:drive-id/items/:driveItem-id/workbook/functions/edate - POSTCreate exact
/drives/:drive-id/items/:driveItem-id/workbook/functions/exact - POSTCreate f_ inv
/drives/:drive-id/items/:driveItem-id/workbook/functions/f_Inv - POSTCreate false
/drives/:drive-id/items/:driveItem-id/workbook/functions/false - POSTFind b (function)
/drives/:drive-id/items/:driveItem-id/workbook/functions/findB - POSTCreate fixed
/drives/:drive-id/items/:driveItem-id/workbook/functions/fixed - POSTCreate gamma
/drives/:drive-id/items/:driveItem-id/workbook/functions/gamma - POSTCreate gauss
/drives/:drive-id/items/:driveItem-id/workbook/functions/gauss - POSTCreate im ab
/drives/:drive-id/items/:driveItem-id/workbook/functions/imAbs - POSTCreate im co
/drives/:drive-id/items/:driveItem-id/workbook/functions/imCos - POSTCreate im cot
/drives/:drive-id/items/:driveItem-id/workbook/functions/imCot - POSTCreate im csc
/drives/:drive-id/items/:driveItem-id/workbook/functions/imCsc - POSTCreate im div
/drives/:drive-id/items/:driveItem-id/workbook/functions/imDiv - POSTCreate im exp
/drives/:drive-id/items/:driveItem-id/workbook/functions/imExp - POSTCreate im sec
/drives/:drive-id/items/:driveItem-id/workbook/functions/imSec - POSTCreate im sin
/drives/:drive-id/items/:driveItem-id/workbook/functions/imSin - POSTCreate im sub
/drives/:drive-id/items/:driveItem-id/workbook/functions/imSub - POSTCreate im sum
/drives/:drive-id/items/:driveItem-id/workbook/functions/imSum - POSTCreate im tan
/drives/:drive-id/items/:driveItem-id/workbook/functions/imTan - POSTCreate is err
/drives/:drive-id/items/:driveItem-id/workbook/functions/isErr - POSTCreate is odd
/drives/:drive-id/items/:driveItem-id/workbook/functions/isOdd - POSTCreate ispmt
/drives/:drive-id/items/:driveItem-id/workbook/functions/ispmt - POSTCreate isref
/drives/:drive-id/items/:driveItem-id/workbook/functions/isref - POSTCreate large
/drives/:drive-id/items/:driveItem-id/workbook/functions/large - POSTCreate leftb
/drives/:drive-id/items/:driveItem-id/workbook/functions/leftb - POSTCreate log10
/drives/:drive-id/items/:driveItem-id/workbook/functions/log10 - POSTCreate lower
/drives/:drive-id/items/:driveItem-id/workbook/functions/lower - POSTCreate match
/drives/:drive-id/items/:driveItem-id/workbook/functions/match - POSTCreate month
/drives/:drive-id/items/:driveItem-id/workbook/functions/month - POSTCreate power
/drives/:drive-id/items/:driveItem-id/workbook/functions/power - POSTCreate price
/drives/:drive-id/items/:driveItem-id/workbook/functions/price - POSTCreate right
/drives/:drive-id/items/:driveItem-id/workbook/functions/right - POSTCreate roman
/drives/:drive-id/items/:driveItem-id/workbook/functions/roman - POSTCreate round
/drives/:drive-id/items/:driveItem-id/workbook/functions/round - POSTCreate sheet
/drives/:drive-id/items/:driveItem-id/workbook/functions/sheet - POSTCreate small
/drives/:drive-id/items/:driveItem-id/workbook/functions/small - POSTCreate sum if
/drives/:drive-id/items/:driveItem-id/workbook/functions/sumIf - POSTCreate sum sq
/drives/:drive-id/items/:driveItem-id/workbook/functions/sumSq - POSTCreate t_ inv
/drives/:drive-id/items/:driveItem-id/workbook/functions/t_Inv - POSTCreate today
/drives/:drive-id/items/:driveItem-id/workbook/functions/today - POSTCreate trunc
/drives/:drive-id/items/:driveItem-id/workbook/functions/trunc - POSTCreate upper
/drives/:drive-id/items/:driveItem-id/workbook/functions/upper - POSTCreate value
/drives/:drive-id/items/:driveItem-id/workbook/functions/value - POSTCreate var p a
/drives/:drive-id/items/:driveItem-id/workbook/functions/varPA - POSTCreate var_ p
/drives/:drive-id/items/:driveItem-id/workbook/functions/var_P - POSTCreate var_
/drives/:drive-id/items/:driveItem-id/workbook/functions/var_S - POSTCreate yield
/drives/:drive-id/items/:driveItem-id/workbook/functions/yield - POSTCreate arabic
/drives/:drive-id/items/:driveItem-id/workbook/functions/arabic - POSTCreate ave dev
/drives/:drive-id/items/:driveItem-id/workbook/functions/aveDev - POSTCreate bitand
/drives/:drive-id/items/:driveItem-id/workbook/functions/bitand - POSTCreate bitxor
/drives/:drive-id/items/:driveItem-id/workbook/functions/bitxor - POSTCreate choose
/drives/:drive-id/items/:driveItem-id/workbook/functions/choose - POSTCreate combin
/drives/:drive-id/items/:driveItem-id/workbook/functions/combin - POSTCreate count a
/drives/:drive-id/items/:driveItem-id/workbook/functions/countA - POSTCreate dcount
/drives/:drive-id/items/:driveItem-id/workbook/functions/dcount - POSTCreate dollar
/drives/:drive-id/items/:driveItem-id/workbook/functions/dollar - POSTCreate dst dev
/drives/:drive-id/items/:driveItem-id/workbook/functions/dstDev - POSTCreate effect
/drives/:drive-id/items/:driveItem-id/workbook/functions/effect - POSTCreate f_ dist
/drives/:drive-id/items/:driveItem-id/workbook/functions/f_Dist - POSTCreate fisher
/drives/:drive-id/items/:driveItem-id/workbook/functions/fisher - POSTCreate ge step
/drives/:drive-id/items/:driveItem-id/workbook/functions/geStep - POSTCreate im cosh
/drives/:drive-id/items/:driveItem-id/workbook/functions/imCosh - POSTCreate im csch
/drives/:drive-id/items/:driveItem-id/workbook/functions/imCsch - POSTCreate im log2
/drives/:drive-id/items/:driveItem-id/workbook/functions/imLog2 - POSTCreate im real
/drives/:drive-id/items/:driveItem-id/workbook/functions/imReal - POSTCreate im sech
/drives/:drive-id/items/:driveItem-id/workbook/functions/imSech - POSTCreate im sinh
/drives/:drive-id/items/:driveItem-id/workbook/functions/imSinh - POSTCreate im sqrt
/drives/:drive-id/items/:driveItem-id/workbook/functions/imSqrt - POSTCreate is even
/drives/:drive-id/items/:driveItem-id/workbook/functions/isEven - POSTCreate is text
/drives/:drive-id/items/:driveItem-id/workbook/functions/isText - POSTCreate lookup
/drives/:drive-id/items/:driveItem-id/workbook/functions/lookup - POSTCreate median
/drives/:drive-id/items/:driveItem-id/workbook/functions/median - POSTCreate minute
/drives/:drive-id/items/:driveItem-id/workbook/functions/minute - POSTCreate mround
/drives/:drive-id/items/:driveItem-id/workbook/functions/mround - POSTCreate permut
/drives/:drive-id/items/:driveItem-id/workbook/functions/permut - POSTCreate proper
/drives/:drive-id/items/:driveItem-id/workbook/functions/proper - POSTCreate rightb
/drives/:drive-id/items/:driveItem-id/workbook/functions/rightb - POSTCreate second
/drives/:drive-id/items/:driveItem-id/workbook/functions/second - POSTCreate sheet
/drives/:drive-id/items/:driveItem-id/workbook/functions/sheets - POSTCreate skew_p
/drives/:drive-id/items/:driveItem-id/workbook/functions/skew_p - POSTCreate sqrt pi
/drives/:drive-id/items/:driveItem-id/workbook/functions/sqrtPi - POSTCreate st dev a
/drives/:drive-id/items/:driveItem-id/workbook/functions/stDevA - POSTCreate sum if
/drives/:drive-id/items/:driveItem-id/workbook/functions/sumIfs - POSTCreate t_ dist
/drives/:drive-id/items/:driveItem-id/workbook/functions/t_Dist - POSTCreate z_ test
/drives/:drive-id/items/:driveItem-id/workbook/functions/z_Test - POSTCreate accr int
/drives/:drive-id/items/:driveItem-id/workbook/functions/accrInt - POSTCreate average
/drives/:drive-id/items/:driveItem-id/workbook/functions/average - POSTCreate bessel i
/drives/:drive-id/items/:driveItem-id/workbook/functions/besselI - POSTCreate bessel j
/drives/:drive-id/items/:driveItem-id/workbook/functions/besselJ - POSTCreate bessel k
/drives/:drive-id/items/:driveItem-id/workbook/functions/besselK - POSTCreate bessel y
/drives/:drive-id/items/:driveItem-id/workbook/functions/besselY - POSTCreate bin2 dec
/drives/:drive-id/items/:driveItem-id/workbook/functions/bin2Dec - POSTCreate bin2 hex
/drives/:drive-id/items/:driveItem-id/workbook/functions/bin2Hex - POSTCreate bin2 oct
/drives/:drive-id/items/:driveItem-id/workbook/functions/bin2Oct - POSTCreate column
/drives/:drive-id/items/:driveItem-id/workbook/functions/columns - POSTCreate combina
/drives/:drive-id/items/:driveItem-id/workbook/functions/combina - POSTCreate complex
/drives/:drive-id/items/:driveItem-id/workbook/functions/complex - POSTCreate convert
/drives/:drive-id/items/:driveItem-id/workbook/functions/convert - POSTCreate count if
/drives/:drive-id/items/:driveItem-id/workbook/functions/countIf - POSTCreate coup ncd
/drives/:drive-id/items/:driveItem-id/workbook/functions/coupNcd - POSTCreate coup num
/drives/:drive-id/items/:driveItem-id/workbook/functions/coupNum - POSTCreate coup pcd
/drives/:drive-id/items/:driveItem-id/workbook/functions/coupPcd - POSTCreate cum i pmt
/drives/:drive-id/items/:driveItem-id/workbook/functions/cumIPmt - POSTCreate days360
/drives/:drive-id/items/:driveItem-id/workbook/functions/days360 - POSTCreate dcount a
/drives/:drive-id/items/:driveItem-id/workbook/functions/dcountA - POSTCreate dec2 bin
/drives/:drive-id/items/:driveItem-id/workbook/functions/dec2Bin - POSTCreate dec2 hex
/drives/:drive-id/items/:driveItem-id/workbook/functions/dec2Hex - POSTCreate dec2 oct
/drives/:drive-id/items/:driveItem-id/workbook/functions/dec2Oct - POSTCreate decimal
/drives/:drive-id/items/:driveItem-id/workbook/functions/decimal - POSTCreate degree
/drives/:drive-id/items/:driveItem-id/workbook/functions/degrees - POSTCreate dst dev p
/drives/:drive-id/items/:driveItem-id/workbook/functions/dstDevP - POSTCreate eo month
/drives/:drive-id/items/:driveItem-id/workbook/functions/eoMonth - POSTCreate gamma ln
/drives/:drive-id/items/:driveItem-id/workbook/functions/gammaLn - POSTCreate geo mean
/drives/:drive-id/items/:driveItem-id/workbook/functions/geoMean - POSTCreate har mean
/drives/:drive-id/items/:driveItem-id/workbook/functions/harMean - POSTCreate hex2 bin
/drives/:drive-id/items/:driveItem-id/workbook/functions/hex2Bin - POSTCreate hex2 dec
/drives/:drive-id/items/:driveItem-id/workbook/functions/hex2Dec - POSTCreate hex2 oct
/drives/:drive-id/items/:driveItem-id/workbook/functions/hex2Oct - POSTCreate hlookup
/drives/:drive-id/items/:driveItem-id/workbook/functions/hlookup - POSTCreate im log10
/drives/:drive-id/items/:driveItem-id/workbook/functions/imLog10 - POSTCreate im power
/drives/:drive-id/items/:driveItem-id/workbook/functions/imPower - POSTCreate int rate
/drives/:drive-id/items/:driveItem-id/workbook/functions/intRate - POSTCreate is error
/drives/:drive-id/items/:driveItem-id/workbook/functions/isError - POSTCreate nominal
/drives/:drive-id/items/:driveItem-id/workbook/functions/nominal - POSTCreate oct2 bin
/drives/:drive-id/items/:driveItem-id/workbook/functions/oct2Bin - POSTCreate oct2 dec
/drives/:drive-id/items/:driveItem-id/workbook/functions/oct2Dec - POSTCreate oct2 hex
/drives/:drive-id/items/:driveItem-id/workbook/functions/oct2Hex - POSTCreate product
/drives/:drive-id/items/:driveItem-id/workbook/functions/product - POSTCreate radian
/drives/:drive-id/items/:driveItem-id/workbook/functions/radians - POSTCreate rank_ eq
/drives/:drive-id/items/:driveItem-id/workbook/functions/rank_Eq - POSTCreate replace
/drives/:drive-id/items/:driveItem-id/workbook/functions/replace - POSTCreate round up
/drives/:drive-id/items/:driveItem-id/workbook/functions/roundUp - POSTCreate st dev p a
/drives/:drive-id/items/:driveItem-id/workbook/functions/stDevPA - POSTCreate st dev_ p
/drives/:drive-id/items/:driveItem-id/workbook/functions/stDev_P - POSTCreate st dev_
/drives/:drive-id/items/:driveItem-id/workbook/functions/stDev_S - POSTCreate tbill eq
/drives/:drive-id/items/:driveItem-id/workbook/functions/tbillEq - POSTCreate unichar
/drives/:drive-id/items/:driveItem-id/workbook/functions/unichar - POSTCreate unicode
/drives/:drive-id/items/:driveItem-id/workbook/functions/unicode - POSTCreate vlookup
/drives/:drive-id/items/:driveItem-id/workbook/functions/vlookup - POSTCreate week num
/drives/:drive-id/items/:driveItem-id/workbook/functions/weekNum - POSTCreate weekday
/drives/:drive-id/items/:driveItem-id/workbook/functions/weekday - POSTCreate work day
/drives/:drive-id/items/:driveItem-id/workbook/functions/workDay - POSTCreate accr int m
/drives/:drive-id/items/:driveItem-id/workbook/functions/accrIntM - POSTCreate amor linc
/drives/:drive-id/items/:driveItem-id/workbook/functions/amorLinc - POSTCreate average a
/drives/:drive-id/items/:driveItem-id/workbook/functions/averageA - POSTCreate baht text
/drives/:drive-id/items/:driveItem-id/workbook/functions/bahtText - POSTCreate beta_ inv
/drives/:drive-id/items/:driveItem-id/workbook/functions/beta_Inv - POSTCreate count if
/drives/:drive-id/items/:driveItem-id/workbook/functions/countIfs - POSTCreate coup day
/drives/:drive-id/items/:driveItem-id/workbook/functions/coupDays - POSTCreate cum princ
/drives/:drive-id/items/:driveItem-id/workbook/functions/cumPrinc - POSTCreate daverage
/drives/:drive-id/items/:driveItem-id/workbook/functions/daverage - POSTCreate dollar de
/drives/:drive-id/items/:driveItem-id/workbook/functions/dollarDe - POSTCreate dollar fr
/drives/:drive-id/items/:driveItem-id/workbook/functions/dollarFr - POSTCreate dproduct
/drives/:drive-id/items/:driveItem-id/workbook/functions/dproduct - POSTCreate duration
/drives/:drive-id/items/:driveItem-id/workbook/functions/duration - POSTCreate f_ inv_ r t
/drives/:drive-id/items/:driveItem-id/workbook/functions/f_Inv_RT - POSTCreate is number
/drives/:drive-id/items/:driveItem-id/workbook/functions/isNumber - POSTCreate norm_ inv
/drives/:drive-id/items/:driveItem-id/workbook/functions/norm_Inv - POSTCreate price mat
/drives/:drive-id/items/:driveItem-id/workbook/functions/priceMat - POSTCreate quotient
/drives/:drive-id/items/:driveItem-id/workbook/functions/quotient
Showing 300 of 400 endpoints. Fork the collection to see all of them.
API details
- Base URL
https://graph.microsoft.com/v1.0- Authentication
- OAuth 2.0 (authorization code, client credentials flows)
- Operations
- 400 operations on 387 pathsPOST 379GET 13PATCH 4DELETE 4
- Main resources
- Drives: items 400
- Description format
- OpenAPI 3.0.4, API version
v1.0 - Links
- Documentation · OpenAPI document
How to test the Microsoft Graph: Excel workbooks in Swastik Codes
- Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
- Fork it into your workspaceChoose a workspace. You get your own copy of the Microsoft Graph: Excel workbooks collection, without the publisher's secrets.
- Add your credentialsThis API uses OAuth 2.0 (authorization code, client credentials flows). Add yours in the collection's variables or an environment; the requests already reference it.
- Send a requestPick an endpoint, for example “Get workbook” (GET /drives/:drive-id/items/:driveItem-id/workbook), and press Send. Check the response, add tests and run the whole collection with the runner.
Frequently asked questions
What is the Microsoft Graph: Excel workbooks?
Read and write Excel workbooks stored in OneDrive or SharePoint: worksheets, ranges, tables, charts, named items and calculations, with or without a session.… It is listed under Productivity & workspace and has 400 endpoints.
Who publishes the Microsoft Graph: Excel workbooks?
It is listed from Microsoft's public API description (an OpenAPI document), not published by Microsoft on Swastik Codes. Anyone who controls microsoft.com can claim the profile by adding a DNS TXT record.
What is the base URL of the Microsoft Graph: Excel workbooks?
Requests go to https://graph.microsoft.com/v1.0. Endpoint paths are added to this base URL.
How do I authenticate with the Microsoft Graph: Excel workbooks?
With OAuth 2.0 (authorization code, client credentials flows).
How many endpoints does the Microsoft Graph: Excel workbooks have?
400 operations on 387 paths (379 POST, 13 GET, 4 PATCH, 4 DELETE). The largest groups are Drives: items.
Is forking the Microsoft Graph: Excel workbooks free?
Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.