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 vote190 views1 answer
C# string console readline array
C#
1 vote173 views2 answers
C# conver date utc to cst
C#
0 vote181 views1 answer
C# performance timer
C#
32 votes186 views4 answers
How to get keyboard input in unity
C#
-1 vote160 views1 answer
Window.location c#
C#
1 vote214 views1 answer
Listview disable resize columns
C#
0 vote180 views1 answer
Unity get game version
C#
2 votes216 views1 answer
C# compile code at runtime
C#
4 votes218 views6 answers
Variable
C#
1 vote238 views1 answer
Nested dictionary c#
C#