read excel file using c# csom

Question

I need to read an excel file which is uploaded in SharePoint online using c# csom

Arun Kumar Tiwari · Answer

Try this, https://www.c-sharpcorner.com/uploadfile/vivekbritish/how-to-downloadread-excel-file-from-sharepoint-library-using-excel-services/ https://medium.com/@guiltabasa/how-to-read-excel-file-from-sharepoint-document-library-net-c-889374826d99 https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html

Mageshwaran R · Answer

Hi, please refer this link: https://www.c-sharpcorner.com/uploadfile/vivekbritish/how-to-downloadread-excel-file-from-sharepoint-library-using-excel-services/

Sanwar Ranwa · Answer

Hello Raghu Please check these Links https://spserengeti.wordpress.com/2015/08/18/is-it-that-difficult-to-read-a-file-from-sharepoint-site/ https://stackoverflow.com/questions/14496608/read-excel-file-stored-in-sharepoint-document-library https://www.c-sharpcorner.com/uploadfile/vivekbritish/how-to-downloadread-excel-file-from-sharepoint-library-using-excel-services/ https://medium.com/@guiltabasa/how-to-read-excel-file-from-sharepoint-document-library-net-c-889374826d99 https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html

Ridwan Dwi Septian Muhaammad · Answer

public DataTable readExcell(string FILE_MAP) { string conn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + FILE_MAP + ";" + "Extended Properties=\"Excel 12.0;HDR=yes;IMEX=1\""; OleDbConnection oledbConn = new OleDbConnection(conn); oledbConn.Open(); DataTable dtData = new DataTable(); DataTable dtSheet = oledbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); if (dtSheet.Rows.Count > 0) { OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" + dtSheet.Rows[0]["TABLE_NAME"].ToString() + "]", oledbConn); OleDbDataAdapter oleda = new OleDbDataAdapter(); oleda.SelectCommand = cmd; oleda.Fill(dtData); } oledbConn.Close(); oledbConn = null; return dtData; }