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 votes113 views1 answer
Unity save list to json
C#
0 vote121 views1 answer
Player ToJson unity
C#
1 vote132 views1 answer
Unity c# check how many of an object exists
C#Unity
0 vote124 views1 answer
C# wtssendmessage
C#
1 vote128 views1 answer
C# determine configration at runtime
C#
1 vote176 views1 answer
Unity custom editor save changes
C#Unity
0 vote76 views1 answer
For i in enumerate(3
C#
6 votes191 views3 answers
Dynamically add rows to datagridview c#
C#
0 vote131 views1 answer
Ontriggerenter unity not working
C#Unity
1 vote118 views1 answer
C# string capital first letter extension method
C#