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 vote163 views1 answer
C# param exception
C#
2 votes133 views1 answer
Start new form c#
C#
0 vote136 views2 answers
RadioButton IsChecked mapped to ENum xmal
C#
-2 votes133 views2 answers
C# .net core memory cache
C#
0 vote133 views1 answer
Push vaiable in array c#
C#
0 vote145 views1 answer
Add npm token to repo
C#
53 votes184 views6 answers
Load scene unity
C#
0 vote137 views1 answer
#ifdef in c
C#
0 vote144 views1 answer
C# solution path
C#
121 votes301 views6 answers
Random number generator c#
C#