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 vote306 views1 answer
C# read lines number 3 from string
C#
0 vote299 views1 answer
C# datatable column alias
C#
0 vote314 views1 answer
How to mock abstract httpcontext using moq .net core
C#
9 votes296 views3 answers
Null check operator used on a null value
C#
0 vote307 views1 answer
Convert number of days into months c#
C#
1 vote320 views1 answer
Hide datagrid column c#
C#
0 vote338 views1 answer
Unity slider not empty
C#Unity
0 vote388 views1 answer
Unity string lowercase
C#Unity
2 votes299 views1 answer
C# implicit operator
C#
0 vote305 views1 answer
C# break file into words
C#