How can you read excel data from sharepoint online library and load it into sql server database? Using c#

Question

I want to read excel data from sharepoint library (online) and load the data in database using c#. I don't want to download file to my local.

Answer 1

You may try Spire.XLS for .NET. It supports to load an Excel file from stream and export data from a specified worksheet to Datatable by using the following C# code.

Workbook book = new Workbook();
book.LoadFromStream(stream);  
DataTable dt = book.Worksheets[0].ExportDataTable(); 

Answer 2

Hi @Nitesh kumar ,
We can use following url get json data of excel file by graph api first

https://graph.microsoft.com/beta/me/drive/items/{id}/workbook/tables('4')/Rows  
https://graph.microsoft.com/beta/me/drive/root:/{item-path}:/workbook/tables('4')/Rows  

Refer to the following link
https://learn.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-beta

Then we can use following code to insert data into the sqlserver

string sql = "INSERT INTO table (name) values (@name)";  
conn.Open();  
SqlCommand cmd = new SqlCommand(sql, conn);  
cmd.Parameters.Add("@name", SqlDbType.VarChar);  
cmd.Parameters["@name"].Value = test;  
cmd.ExecuteNonQuery();  

---

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.