Writing to XLSM excel files using Graph API

Question

Hi team,

I am writing to enquire about whether it is possible to write to an xlsm excel files using Graph API.

We currently have an integration with Microsoft Excel where we export some data to an excel file in one drive/SharePoint. Writing to normal xlsx files works, but when we try to retrieve a macro enabled excel file (xlsm), it is not detected.

Hence, I would really appreciate it if you could confirm if this is possible, and if possible also direct me to the resource on how this can be achieved.

Cheers

Answer 1

Hello Thanks for reaching out. What error are your getting when retrieving an XLSM file via Graph. What URI are your using to retrieve the file? In my testing I was able to get and write contents to an XSLM file stored in OneDrive.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.

Answer 2

Hello Ming,

Good Day. Hope all is well.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

Thanks.