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

1 vote311 views1 answer
Consecutive numbers c#
C#
1 vote297 views1 answer
Unity lookrotation lerp
C#Unity
0 vote281 views2 answers
Jquery: return true or false if the element is present in the DOM or not
C#
0 vote266 views1 answer
Edit pdf itextsharip
C#
1 vote263 views1 answer
C# write text before user input
C#
2 votes273 views1 answer
Unity player look at mouse
C#
9 votes303 views2 answers
Quit button unity
C#
7 votes259 views2 answers
C# randomize a list
C#
0 vote290 views1 answer
C# method summary new line
C#
3 votes287 views1 answer
How to make a pause feautre in unity
C#