how do I add rows to excel file in sharepoint , in c# asp.net core 5.0 mvc application programatically

amnshuman sunil 1 Reputation point
2021-10-28T08:19:00.823+00:00

Hi

I am trying to create an MVC application where a user fills a form and the filled details will update the cell values of an excel sheet placed in share point location, please redirect me to any document for doing this.

Thanks in advance :)

Developer technologies ASP.NET ASP.NET Core
Microsoft 365 and Office SharePoint For business Windows
Developer technologies C#
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MichaelHan-MSFT 18,126 Reputation points
    2021-10-29T06:54:16.687+00:00

    Hi @amnshuman sunil ,

    It would be easy to achieve this via Graph API. You could refer to this documentation for more: https://learn.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

    Graph API provides the method to create row in a excel file : https://learn.microsoft.com/en-us/graph/api/table-post-rows?view=graph-rest-1.0&tabs=csharp


    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.


    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.