Changes not applied to Excel file after calculation using MS Graph API

I'm using Python to create a wrapper for MS Graph Excel API to handle calculation.

from typing import Any, Union
from urllib.parse import urljoin

import requests


class MsGraph:
    _graph_uri = "https://graph.microsoft.com/v1.0/"

    def __init__(self, token: str, file_path: str):
        self.file_path = file_path
        self.token = token
        self.request_headers = {"Authorization": f"Bearer {self.token}"}

    def _call_api(self, endpoint: str, req_type="GET", payload=None, headers=None) -> Any:
        if headers:
            headers.update(self.request_headers)
        else:
            headers = self.request_headers
        endpoint = self._sanitize_endpoint(endpoint)

        kwargs = {"headers": headers}

        if payload:
            kwargs["json" if "json" in headers.get("Content-Type") else "data"] = payload

        resp = requests.request(req_type, endpoint, **kwargs)
        resp.raise_for_status()
        if resp.status_code is requests.codes.no_content:
            return resp.text

        if resp.status_code is requests.codes.found:
            return resp.text

        return resp.json()

    def _sanitize_endpoint(self, uri: str) -> str:
        if uri.startswith(self._graph_uri):
            return uri
        return urljoin(self._graph_uri, uri)

    def list_onedrive_files_for_auth_user(self) -> Any:
        return self._call_api("me/drive/root/children")

    def get_onedrive_id_from_user(self) -> Any:
        return self._call_api("me/drives")

    def get_onedrive_id_for_app(self) -> Any:
        return self._call_api("drives")

    def upload_to_onedrive(self, file_name: str, content: Union[bytes, str]) -> Any:
        """content: file content in the text/binary form """
        headers = {"Content-Type": "text/plain"}
        drive_uri = f"me/drive/root:/{file_name}:/content"
        return self._call_api(drive_uri, "PUT", content, headers)

    def excel_read(self, drive_item_id: Any) -> Any:
        return self._call_api(f"me/drive/items/{drive_item_id}/workbook/worksheets")

    def excel_create_session(self, drive_item_id: Any) -> Any:
        headers = {"Content-Type": "application/json"}
        payload = {"persistChanges": True}

        uri = f"me/drive/items/{drive_item_id}/workbook/createSession"
        return self._call_api(uri, "POST", payload, headers)

    def excel_close_session(self, drive_item_id: Any, persist_session_id: str) -> Any:
        headers = {
            "Content-Type": "application/json",
            "workbook-session-id": persist_session_id
        }

        uri = f"me/drive/items/{drive_item_id}/workbook/closeSession"
        return self._call_api(uri, "POST", None, headers)

    def excel_calculate(self, drive_item_id: Any, persist_session_id: str, calc_type="FullRebuild") -> Any:
        supported_types = ["Recalculate", "Full", "FullRebuild"]
        if calc_type not in supported_types:
            raise AttributeError(
                f"calculation type '{calc_type}' need to be one of supported: {supported_types}"
            )
        headers = {
            "Content-Type": "application/json",
            "workbook-session-id": persist_session_id
        }
        payload = {"calculationType": calc_type}

        calc_uri = f"me/drive/items/{drive_item_id}/workbook/application/calculate"
        return self._call_api(calc_uri, "POST", payload, headers)

    def download_from_onedrive(self, drive_item_id: Any, file_path: str) -> None:
        uri = f"{self._graph_uri}/me/drive/items/{drive_item_id}/content"
        response = requests.get(uri, headers=self.request_headers)
        with open(file_path, "wb") as handle:
            handle.write(response.content)

    def delete_from_onedrive(self, drive_item_id: Any) -> Any:
        drive_uri = f"me/drive/items/{drive_item_id}"
        return self._call_api(drive_uri, "DELETE")

    def read_excel_from_path(self) -> bytes:
        with open(self.file_path, "rb") as excel_file:
            return excel_file.read()

I managed to authorize and get tokens. File uploads correctly, persistent session creates correctly, calculation triggers without any errors, but after all I want to download the Excel file with recalculated formulas. Unfortunately, formulas didn't reevaluate and I see the old data (doing this programatically using Apache POI).

        msgraph = MsGraph(token, file_path)
        excel_file_content = msgraph.read_excel_from_path()

        file_name = os.path.basename(file_path)
        drive_item = msgraph.upload_to_onedrive(file_name, excel_file_content)
        persist_session_response = msgraph.excel_create_session(drive_item["id"])
        msgraph.excel_calculate(drive_item["id"], persist_session_response["id"])
        msgraph.excel_close_session(drive_item["id"], persist_session_response["id"])
        msgraph.download_from_onedrive(drive_item["id"], file_path)
        msgraph.delete_from_onedrive(drive_item["id"])

Excel formulas seem to be filled correctly, because when I open them with Excel Online GUI and trigger reevaluation/calculation with F9, everything gets updated correctly. Not sure what I'm doing wrong. Tried { persistSession: true } (and false and without creating a session).

source https://stackoverflow.com/questions/73057052/changes-not-applied-to-excel-file-after-calculation-using-ms-graph-api