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 vote246 views1 answer
How to do time.deltatime in c#
C#
0 vote228 views1 answer
C# clear linkList
C#
2 votes259 views1 answer
How to type to console in unity
C#
1 vote252 views1 answer
How to add a gameobject
C#
0 vote252 views1 answer
T SQL Format GetDate()
C#
0 vote235 views1 answer
Tachyons
C#
0 vote262 views1 answer
Npm install --save vue-route@n
C#
0 vote252 views1 answer
C# if isset
C#
2 votes287 views1 answer
Camera follow player unity smooth
C#Unity
0 vote233 views1 answer
Tecla intro en unity
C#