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)