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 vote148 views1 answer
Unity stop object from rotating
C#
0 vote106 views1 answer
Xamarin hide back button
C#
0 vote119 views1 answer
C# how to refresh input field
C#
0 vote127 views1 answer
How to add a ddos api to a c# console app
C#
0 vote145 views1 answer
Tooltip button winform
C#
5 votes108 views1 answer
Unity how to get fps c#
C#
0 vote97 views1 answer
Dotnet core vue in subdirectory
C#
12 votes106 views2 answers
C# string equals ignore case
C#
1 vote156 views1 answer
Unity C# make object face away
C#Unity
0 vote115 views1 answer
How to make game object transparent in unity
C#