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 vote238 views1 answer
Code to disable Debug.log
C#
-1 vote234 views1 answer
How to add colider in obj in unity 2020
C#Unity
0 vote180 views1 answer
.net core change localhost port
C#
0 vote166 views1 answer
C# isalphanumeric
C#
0 vote175 views1 answer
C# remove newline from string
C#
4 votes258 views2 answers
How to make among us clone in unity
C#Unity
0 vote164 views1 answer
Datagridview column color c#
C#
1 vote161 views1 answer
Wpf label text color rgb string
C#
5 votes128 views1 answer
C# linq to dictionary
C#
1 vote163 views1 answer
Bower azure repository tag
C#