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

1 vote257 views1 answer
C# unity follow object
C#
1 vote250 views1 answer
NET Framework 4.7.1 or a later update is already installed on this computer.
C#
0 vote255 views1 answer
Vb.net windows version check
C#
17 votes271 views5 answers
Linux delete content of folder
C#
0 vote283 views1 answer
Optional parameter get request c#
C#
0 vote282 views1 answer
C# obsolete class
C#
0 vote267 views1 answer
Wait some seconds without blocking UI execution
C#
128 votes437 views6 answers
C# random number
C#
4 votes216 views1 answer
Base keyword in c# constructor
C#
1 vote304 views1 answer
How to make int in c#
C#