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

3 votes129 views1 answer
Initialise icollection c#
C#
1 vote124 views2 answers
Get tag unity
C#
0 vote127 views1 answer
C# usermanager update user
C#
1 vote118 views1 answer
Mvc foreach
C#
1 vote156 views1 answer
Unity set parent to root
C#Unity
0 vote1K views2 answers
Process.start web
C#
4 votes128 views2 answers
OpenFileDialog c#
C#
13 votes121 views2 answers
C# create a text file
C#
0 vote122 views1 answer
Nunit cleanup after all tests
C#
53 votes300 views6 answers
Load scene unity
C#Unity