This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 95%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Hi Team,
I'm trying to set the borders to excel cells in onedrive by using Graph API(POST method).
but getting 405 error .PFA
NOTE: I'm able to do GET call for the same endpoint..(PFA)
ref: https://learn.microsoft.com/en-us/graph/api/rangeformat-post-borders?view=graph-rest-1.0&tabs=http
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 0%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Hi @TejNaveenChintakunta-5813, this endpoint requires the PATCH method, I just tested it locally and it worked. Hope can help you. Best Wishes.
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.
Hi @Zehui Yao_MSFT .
Thanks for responding ,
Yes With 'Patch' method I'm able to get "
OK - 200"
but it is not reflecting in Excel file :(
Can you please confirm that your excel file updated with borders
Hi @TejNaveenChintakunta-5813, thanks for alerting me to this issue, it is true that according to the documentation using the POST method to create a new range border will always prompt an error.
So far, I've found that updating an existing Range Border (You can get it via the GET method, just like your first URL) using the PATCH method can make changes to the Excel file.
Not sure if this meets your needs.
Hi @TejNaveenChintakunta-5813, you can use JSON batching to combine multiple requests to achieve the effect of simultaneous updates, I tested it locally and ran it successfully, I don't know if it meets your needs. Hope this helps.
Hi @TejNaveenChintakunta-5813, since we need to contact the product team to determine if this is an existing issue and it will take some time to wait for a response, you can also open a support ticket to communicate with a back-end engineer for more information. Thank you for your understanding.