workbook calc speed and general performance with graph api

ThorCRE 1 Reputation point

when using graph api with an excel workbook to calculate values, how do we manage speed?

it's not clear how this is working in the back end, but i figure it is loosely tied to azure. however, i don't see a way to add resources in azure to the graph api.

is there a way to "buy" performance in any way?

also, are there any limitations as to the volume of calculations you can run through the graph api in this way? one or two calcs seem fine, but what about hundreds/thousands/millions?

since it's presumably opening excel in the background somehow, updating the spreadsheet, then calculating, is this all happening on the same machine, or is it different/separate machines operating in parallel? (assuming i have persistchanges=false)

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
9,935 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Zehui Yao_MSFT 5,806 Reputation points

    Hi @ThorCRE , At present, the documentation does not point out that there is a clear limit on the amount of calculation.
    You can communicate with the back-end engineer by opening a support ticket, and the back-end engineer can view the back-end data operation status.

    If the persistchanges=false, this means API calls are made without session information.
    The Excel server must find the server's copy of the workbook every time to perform the operation, so this is not an efficient way to call the Excel API. It is suitable for making a one-time request.
    At present, the document proposes to add session header to increase computing performance, I hope this can help you.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments