How to insert excel sheet data into sharepoint using vb.net or c# windows application

Question

Hi All,
I want to design windows application and it needs to support to dump excel sheet records into share point using vb.net or c# windows application. Please guide me on this.

Answer 1

@Murari Ram

Tag “office-online-server-sharepoint” focuses on technical questions about integrating Office Online Server with SharePoint Server.
Since your issue is more related to SharePoint development which is out of our scope of support.
I would modify the tag to be “sharepoint-apps-general-dev”.
Thanks for your understanding.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.

Answer 2

Hi @Murari Ram ,
You could try to use SSOM or CSOM.
My test SSOM code for your reference(SSOM can only be used for SharePoint Server):

    String fileToUpload = @"C:\Users\Administrator.CONTOSO\Desktop\workflowList.csv";  
    String sharePointSite = "http://sp";  
    String documentLibraryName = "Shared Documents";  

    using (SPSite oSite = new SPSite(sharePointSite))  
    {  
        using (SPWeb oWeb = oSite.OpenWeb())  
        {  
            if (!System.IO.File.Exists(fileToUpload))  
                throw new FileNotFoundException("File not found.", fileToUpload);  

            SPFolder myLibrary = oWeb.Folders[documentLibraryName];  

            // Prepare to upload  
            Boolean replaceExistingFiles = true;  
            String fileName = System.IO.Path.GetFileName(fileToUpload);  
            FileStream fileStream = File.OpenRead(fileToUpload);  

            // Upload document  
            SPFile spfile = myLibrary.Files.Add(fileName, fileStream, replaceExistingFiles);  

            // Commit   
            myLibrary.Update();  
        }  
    }  

More threads for your reference:

1. How to: Upload a File to a SharePoint Site from a Local Folder
2. Upload A Document To A SharePoint 2013 Library Using Client Side Object Model

   ---

If the response is helpful, please click "Accept Answer" and upvote it.
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.