Is there a way for multiple users on different machines to write form input to the same Excel file on SharePoint from a C# WinForm program?

Question

I am writing a C# program that gathers statistics on workflow at various workstations. The form has a mix of combo boxes, text boxes, radio buttons, etc. whose values all need to be written chronologically at the click of a Submit button to the same Excel file in SharePoint, likely by multiple users on different workstations. Is there a way to do this?

I've done some research into how to write to an Excel file and a list on SharePoint, but haven't found anything that shows how add to an existing Excel file on SharePoint. All of the users have their own work email used to log into various services, such as the SharePoint site, but an account can be made specifically for the program if permissions will be an issue.

Could you use a SharePoint form, like this instead of creating a separate app? While I'm sure it's doable, most of the suggestions I've found don't recommend using a shared Excel file as a writable data source within your own application. — Scott Hannen
Unfortunately, a form like that wouldn't work. We need the program to be able to run on startup/login and be something that can have most of the fields stay filled in so we can just click "Submit" if we get a lot of patrons in a short period of time without having to spend extra time filling everything in again. — jpollock0010

Farhan Farhan · Accepted Answer · 2019-05-14T18:24:03

yes it is possible if all the users have edit access to the file and you are using SharePoint managed csom or rest apis for that.

Is there a way for multiple users on different machines to write form input to the same Excel file on SharePoint from a C# WinForm program?

1 Answers