Is there any API available to run excel script via API?

ffbld01@uk.ibm.com 96 Reputation points
2022-03-29T12:30:55.317+00:00

We see that Microsoft power automate allows users to select and run the automation scripts on the user's excel files. I tried to find any API which allows us to do the same job using an API such as excel Rest API or MS Graph REST API but so far we did not find any such API. I'm not unable to comprehend how is ms power automate achieving it internally if there is no such APIs available?

  • Request the team here to please point us to any option which can allow the user to run the excel automation script preferably via MS Graph API.
  • If Graph API does not have any such option, I will request you to please let us know if there is any other API that has such options.
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,640 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. 2022-03-30T13:45:45.967+00:00

    Hi @ffbld01@uk.ibm.com , Thanks for reaching out.
    The feature to run automation script for excel files using MS Graph REST API is not available at the moment, if you want to raise a feature request for it Feature request.

    ----------

    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

  2. ffbld01@uk.ibm.com 96 Reputation points
    2022-04-04T11:40:19.963+00:00

    Thanks for the quick response. I was curious to know if not the MS-Graph API, is there any other API that allows running a script over excel files?


  3. ffbld01@uk.ibm.com 96 Reputation points
    2022-04-12T04:40:13.44+00:00
    • Yes you are correct, I'm NOT talking about traditional VB script
    • I'm talking about Office Scripts for Excel on the web
    • I want to allow users to see the available scripts on their Business one drive account before they select which one to run on any workbook (Just like MS power automate)
    • I want to allow users to run the selected script against any selected workbook (Just like Ms power automate allowed users to do)
    • We were wondering how is ms power automate achieving this thing? They must also be using some API to allow user to execute script on excel file