Is there any usable way to copy Microsoft Excel sheets using the Graph API only?

Question

Scenario

I am developing an RPA integration application that automates several services, including Microsoft services via their APIs (specifically Microsoft Graph). I want to copy sheets in Microsoft Excel, but the Graph API does not fully support this feature as anticipated.

Current Approach

Currently, I am using the Get Used Range API, which retrieves only the data without including styling (fonts, borders, colors, etc.). To work around this, I am iterating over the cells to copy each cell's styling:

for row in rows:
    for col in cols:
        font_cell = requests.get(font_link_source, headers=headers)
        requests.patch(font_link_target, headers=headers, json=font_cell)

This process is extremely slow; copying the fonts for every cell takes around 10 minutes.

Question

Is there any API available that could simplify this issue? Thank you for the assistance!

Answer 1

Hello Juan Jimmy,

Thank you for reaching out to Microsoft!!

For the query if there is any available API that could simplify the issue of copying the fonts very slowly,

Unfortunately, there is no Graph API as there is only a single way that is already being used. You can submit this feature request using the link mentioned below, which will be monitored by Microsoft team and make the enhancements to Graph API.

Link: support link

As an alternative or workaround, you can prefer using the Excel Java Script APIs from the Office Dev samples as mentioned in the below link. It offers a method called Range.copyForm that can copy both data and formatting in a single operation.

Link: Copy Cells

Hope this helps.

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