read excel file using c# csom

raghu

8y5.3kVisual Basic .NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arun Kumar Tiwari6y ago
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 R6y ago
Hi,
please refer this link:
https://www.c-sharpcorner.com/uploadfile/vivekbritish/how-to-downloadread-excel-file-from-sharepoint-library-using-excel-services/
Sanwar Ranwa8y ago
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 Muhaammad8y ago
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;
}