Creating an Excel Workbook

[Lydia]

Does anyone have enough api chops to help me to create a excel workbook file prior to populating it with a worksheet and filling in rows?

Basically I want to store some data from Monday.com into an excel workbook. For each item, I want a new workbook.

Make.com has modules for adding worksheets to an existing workbook, but I’d like to create a new workbook, not just a new worksheet.

As a non-programmer, I’m sort of going cross-eyed as I try to read the Microsoft Graph REST API documentation that I assume I would need to sift through in order to perform my own GraphQL on Make.com

Any advice, help?

[Olly_Ats]

Hey @Lydia

You can use the ‘MS 365 Excel - Make an API call’ module set up this way:

Here is the ‘body’ string which you can edit:

{"file":{},"name":"test.xlsx","@microsoft.graph.conflictBehavior":"rename"}

I hope this helps you.