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

0 vote428 views1 answer
.net framework cheat sheet
C#
0 vote308 views1 answer
How to write a ello world program in c#
C#
4 votes305 views1 answer
How to get rigidbody speed in unity
C#
0 vote333 views1 answer
C# regex replace all spaces with blank
C#
1 vote325 views1 answer
C# sql duplicate key exception
C#
-1 vote318 views2 answers
C# extend array
C#
5 votes357 views2 answers
How to get element dictionary key in c# by index
C#
15 votes321 views10 answers
Hello world
C#
13 votes359 views1 answer
What does static mean in c#
C#
0 vote400 views1 answer
C# datetime dd/mm/yyy hh:mm:ss
C#