Read Excel using c# in Visual Studio 2015

Question

Hi friends, I need to read a excel sheet using c # in visual studio 2015 But i am not sure about refer the required libraries to do it. Kindly provide me the steps to be done to do these in visual studio 2015.

Matthew Mickelson · Answer

There is an open source Excel library available -NPOI, You could find it from: http://npoi.codeplex.com/ How to read in XLSX data for editing with NPOI: http://www.zachhunter.com/2010/05/read-xlsx-data-for-npoi/ If you have other requirements to manipulate Excel using C#, I recommend you to have a look at Spire.XLS: http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Spire.XLS-Program-Guide-Content.html

Ravi Kumar · Answer

check the fallowing code DataTable dt = new DataTable(); SqlConnection strConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); strConnection.Open(); string filepath = textBox1.Text; string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=Excel 12.0;"; //Create Connection to Excel work book OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); excelConnection.Open(); OleDbDataAdapter da = new OleDbDataAdapter("Select [ISBN/Code],[Title],[Publisher],[Author],[Qty],[Price],[Rate In INR],[Disc%],[Value In INR],[Category] from [Sheet1$]", excelConnection); Thread.Sleep(2000); da.Fill(dt);

Vipan Sharma · Answer

Dear Suresh , Kindly follow the below link, http://www.codeproject.com/Tips/696864/Working-with-Excel-Using-Csharp Very good work done by author, It fulfill all your requirement. Also Sample Application attached in it. Hope it will help you . Accept answer, So it will help next developer to find right option Vipan

Nilesh Jadav · Answer

Hey ! Check out this Link : 1) http://www.aspsnippets.com/Articles/Read-and-Import-Excel-File-into-DataSet-or-DataTable-using-C-and-VBNet-in-ASPNet.aspx 2) https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html 3) http://www.codeproject.com/Tips/801032/Csharp-How-To-Read-xlsx-Excel-File-With-Lines-of 3)

Read Excel using c# in Visual Studio 2015

Answers (4)