Reading Excel files from C#

var fileName = string.Format("{0}\\fileNameHere", Directory.GetCurrentDirectory());
var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", fileName);

var adapter = new OleDbDataAdapter("SELECT * FROM [workSheetNameHere$]", connectionString);
var ds = new DataSet();

adapter.Fill(ds, "anyNameHere");

DataTable data = ds.Tables["anyNameHere"];

Source: stackoverflow.com

Similar codes

8 votes340 views2 answers
C# add string to array
C#
0 vote344 views1 answer
C# use enum in class
C#
1 vote351 views1 answer
C# set a guid
C#
130 votes577 views6 answers
Generate random number c#
C#
2 votes377 views1 answer
Unity deactivate all colliders of a gameobject
C#Unity
0 vote363 views1 answer
Unity making homing missile
C#Unity
2 votes363 views1 answer
C# get vector2 distance
C#
0 vote321 views1 answer
How to type custom backcolor on c# winform
C#
2 votes317 views1 answer
C# Thread Sleep vs Task Delay
C#
0 vote346 views1 answer
Monogame button
C#