How to execute microsoft excel office script programmatically?

Question

We have been moving towards writing office scripts instead of VBA macros. I am also aware of the Microsoft Graph REST APIs for excel. Can someone guide me how can I execute an office script (like a sample one below) programmatically without creating an excel instance locally?


async function main(context: Excel.RequestContext) {
  // Set range A1 on selectedSheet
  let workbook = context.workbook;
  let worksheets = workbook.worksheets;
  let selectedSheet = worksheets.getActiveWorksheet();
  selectedSheet.getRange("A1").values = [
    ["Hello World"]
  ];
}

I could not find any graph api to do so.

Thanks.

Yes, that could be done by either taking the user credentials before hand and generate the access token using the OAuth2 api's but I am also sure that the excel graph api's would in future support application permissions like other resources do. The problem is there is no API to run an office script. Are you saying there would be in near future to do so @RaymondLu? — Andy Dufresne
– Andy Dufresne, Commented Jun 8, 2020 at 13:51

Joe Zhao · Accepted Answer · 2020-06-11 01:11:51Z

2

To run office script via Graph API, there would be two requirements: 1. Office JS library: parse the office script to build the request and also parse the result in response. 2. Specific Graph API: run the request in service side against the target file.

Unfortunately, none of them is availabe now.

However, there is another ongoing work to integrate Office Scripts with PowerAutomate, which will enable us to run the scripts against a workbook on PowerAutomate (without a local Excel instance). Here (https://mybuild.microsoft.com/sessions/bc1bc3e6-9dc1-474e-a5d6-409af2fa0ad3?source=sessions) is the video to introduce Office Scripts (and also its integration with PowerAutomate) in recent Microsoft Build. This feature would be in public preview soon.

edited Jun 11, 2020 at 1:11

answered Jun 10, 2020 at 2:22

Joe Zhao

462 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Joe Zhao Over a year ago

There is an ongoing work to integrate Office Scripts with PowerAutomate, which will enable us to run the scripts against a workbook on PowerAutomate (without a local Excel instance). Here (mybuild.microsoft.com/sessions/…) is the video to introduce Office Scripts (and also its integration with PowerAutomate) in recent Microsoft Build. This feature would be in public preview soon.

Andy Dufresne Over a year ago

That's great @Joe Zhao. If you could convert your notes from the comment to the post, I could accept it as an answer.

Joe Zhao Over a year ago

I merged the comments to my previous answer.

Yutao Huang · Accepted Answer · 2020-08-01 04:20:20Z

2

Microsoft has announced the Office Scripts integration with Microsoft Power Automate (preview), where you can run your Office Scripts with schedule-based triggers or event-based triggers.

Here are a few links that might be helpful:

answered Aug 1, 2020 at 4:20

Yutao Huang

1,5913 gold badges13 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to execute microsoft excel office script programmatically?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related