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

2 votes401 views1 answer
Change array size in unity
C#Unity
7 votes330 views1 answer
How to detect a mouse click in unity
C#
1 vote345 views2 answers
C# how to call methods from another class
C#
0 vote361 views1 answer
EF .NET4 INSERT IMPROVE PERFORMACE
C#
1 vote371 views1 answer
Make string
C#
7 votes383 views1 answer
Unity change tag in script
C#Unity
0 vote406 views1 answer
ASP.NET Web Forms TextBox
C#
0 vote356 views1 answer
Button commandfield commandargument pass textbox
C#
0 vote357 views1 answer
Sorting a list of objects in c#
C#
2 votes405 views2 answers
Inactive after active with press key unity
C#Unity