How can I get the status of calculation request when using Workbook /calculate endpoint?

Sankalp 0 Reputation points
2024-05-21T08:36:06.9+00:00

I am using the Microsoft Graph API endpoint /calculate for workbook recalculation, but it does not provide a way to poll for the status of the calculation asynchronously. After making a POST request to this endpoint, it initiates the calculation process and simply returns a 200 OK status

My use case involves -

  1. Write a cell
  2. Recalculate workbook
  3. Read another cell

But, the detailed workbook takes anywhere from 10-60 seconds to recalculate hence I need a flag for status or polling example/endpoint to solve this. I have also tried openpyxl and other implementations without luck

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,227 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,793 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,966 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.