How to upload excel file in share point folder using C# ?

Question

I need to upload a CSV or Excel file to a SharePoint folder using a C# application. Could you please assist with this? How can this be accomplished in C#?

Vishal Yelve · Answer

Hi Jignesh, https://learn.microsoft.com/en-us/answers/questions/1517434/how-to-upload-a-file-to-a-sharepoint-driveitem-fol https://medium.com/@mitchelldalehein25/uploading-files-to-sharepoint-using-microsoft-graph-api-c-0edc689fb388

Jayraj Chhaya · Answer

Hi The SharePointOnlineCredentials class is part of the SharePoint Client Components SDK, which is compatible with .NET Framework versions 4.5 and later. This class is specifically designed for authenticating against SharePoint Online using the SharePoint Client Object Model. To utilize SharePointOnlineCredentials , ensure that you have the appropriate NuGet package installed, typically Microsoft.SharePointOnline.CSOM . Install-Package Microsoft.SharePointOnline.CSOM Once the package is installed, you should be able to use SharePointOnlineCredentials without any issues. If you are still encountering problems, verify that your project is targeting a compatible version of the .NET Framework and that all necessary references are correctly set up. context.Credentials = new SharePointOnlineCredentials("yourusername@domain.com", GetSecureString("yourpassword")); This line effectively sets the credentials for the ClientContext , allowing you to interact with SharePoint Online securely.

Jignesh Kumar · Answer

In which version it will work ? context.Credentials = new SharePointOnlineCredentials("yourusername@domain.com", GetSecureString("yourpassword")); I am not getting this one SharePointOnlineCredentials()

Jayraj Chhaya · Answer

Hi @Jignesh Kumar, To upload an Excel or CSV file to a SharePoint folder using C#, you can leverage the SharePoint Client Object Model. using System; using System.IO; using Microsoft.SharePoint.Client; class Program { static void Main(string[] args) { string siteUrl = "https://yoursharepointsite.com"; string folderUrl = "/sites/yoursite/Shared Documents/YourFolder"; string filePath = @"C:\path	o\yourfile.xlsx"; using (ClientContext context = new ClientContext(siteUrl)) { context.Credentials = new SharePointOnlineCredentials("yourusername@domain.com", GetSecureString("yourpassword")); using (FileStream fs = new FileStream(filePath, FileMode.Open)) { FileCreationInformation newFile = new FileCreationInformation { ContentStream = fs, Url = Path.GetFileName(filePath), Overwrite = true }; Microsoft.SharePoint.Client.File uploadFile = context.Web.GetFolderByServerRelativeUrl(folderUrl).Files.Add(newFile); context.Load(uploadFile); context.ExecuteQuery(); } } } private static SecureString GetSecureString(string password) { SecureString secureString = new SecureString(); foreach (char c in password) { secureString.AppendChar(c); } return secureString; } } NOTE :- Replace the placeholders with your actual SharePoint site URL, folder path, and file details. This code establishes a connection to SharePoint, reads the specified file, and uploads it to the designated folder. Ensure you have the necessary permissions and references to the SharePoint Client assemblies in your project.

How to upload excel file in share point folder using C# ?

Answers (4)