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 vote170 views1 answer
Set data annotation in model c#
C#
9 votes228 views2 answers
Exit button unity code
C#Unity
0 vote190 views1 answer
C# open config file by path
C#
4 votes154 views1 answer
Unity round float to nearest 10
C#
14 votes212 views4 answers
Unity call function from another script
C#Unity
0 vote229 views1 answer
Convert object to iqueryable in c#
C#
1 vote169 views1 answer
C# empty char
C#
0 vote179 views1 answer
How to hide tree level button when no record found for devexpress child grid view in Winform c#
C#
0 vote156 views3 answers
Get color of pixel c#
C#
10 votes175 views4 answers
React build command
C#