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 vote172 views1 answer
Get all devices in game unity
C#Unity
4 votes122 views1 answer
Asp.net data annotations email
C#
0 vote120 views1 answer
Add float value to ui text in unity
C#
5 votes177 views10 answers
C#
C#
4 votes117 views4 answers
C# datagridview hide column
C#
0 vote142 views1 answer
Player not following slide object unity 2d
C#Unity
0 vote187 views1 answer
Fade image out unity
C#Unity
0 vote147 views1 answer
Console.WriteLine($"Hello {Ana.ToUpper($)}!");
C#
1 vote128 views1 answer
Add tag helpers asp.net core in viewimports
C#
0 vote130 views1 answer
C# sprintf equivalent
C#