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 votes146 views3 answers
Unity create a child object
C#
37 votes490 views5 answers
Unity key down
C#Unity
0 vote155 views1 answer
C# 2 timespan return yesterday
C#
7 votes151 views3 answers
C# datetime to timestamp
C#
0 vote142 views1 answer
Long, Max and Min value
C#
0 vote168 views1 answer
How to do division with button C#
C#
0 vote158 views1 answer
.net core copy file in folder to root
C#
1 vote145 views1 answer
How to have is trigger on but also have collisions
C#
0 vote118 views1 answer
Maximize window c# console
C#
0 vote149 views1 answer
Textblock line break
C#