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

7 votes134 views2 answers
Unity float from another script
C#
1 vote122 views1 answer
C# remove accents
C#
0 vote165 views1 answer
How to authorize token when consuming api in c#
C#
1 vote129 views1 answer
Ensuresuccessstatuscode exception
C#
0 vote127 views1 answer
C# datetime.now to string only numbers
C#
0 vote137 views1 answer
Aspx import namespace
C#
2 votes145 views1 answer
SieveOfEratosthenes
C#
0 vote138 views1 answer
Telerik wpf gridviewcombobox itemsource property on item
C#
6 votes89 views1 answer
Movement slowly towards target unity
C#
0 vote132 views1 answer
C# extract after what is
C#