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

10 votes150 views4 answers
React build command
C#
0 vote129 views1 answer
Clickable table row asp.net core cursor
C#
0 vote142 views1 answer
List string to file C#
C#
15 votes131 views2 answers
C# double value with 2 decimal places
C#
0 vote170 views1 answer
C# invokerequired wpf
C#
0 vote147 views1 answer
How to get previous page url aspnet core
C#
3 votes162 views1 answer
Math operations in c#
C#
2 votes145 views2 answers
How to create directory folder in c#
C#
0 vote147 views1 answer
Get gameobject active state
C#
3 votes145 views1 answer
How to make a pause feautre in unity
C#