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 vote219 views1 answer
Display none asp.net
C#
0 vote222 views1 answer
Exception handling c# stack overflow
C#
9 votes748 views2 answers
C# null conditional
C#
0 vote218 views1 answer
List of 2 different iherent classes c#'
C#
13 votes221 views5 answers
C# list to string
C#
2 votes223 views1 answer
C# enum default
C#
0 vote221 views2 answers
CS0120: An object reference is required for the non-static field, method, or property 'PlayerControls.currentState'
C#
0 vote230 views1 answer
How to add a variable in unity c#
C#Unity
2 votes228 views1 answer
Blazor button onclick parameter
C#
0 vote210 views1 answer
Fix Array outside the bonus
C#