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 vote121 views1 answer
How to pass a model in a partial view
C#
4 votes166 views2 answers
Selenium c# maximize window
C#
-1 vote204 views1 answer
Web scraping dynamic content c#
C#
7 votes180 views2 answers
C# randize list
C#
2 votes153 views1 answer
C# press key
C#
0 vote165 views1 answer
Adding values to a dictionary via inline initialization of its container
C#
0 vote163 views1 answer
Particles are pink - creating tex and material
C#
0 vote216 views1 answer
Reflection assemblies gettypes
C#
1 vote168 views1 answer
Remove index from array c#
C#
65 votes218 views6 answers
Unity reload scene
C#