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

2 votes320 views1 answer
Get enum int by name
C#
1 vote321 views1 answer
Make string
C#
2 votes301 views2 answers
Remove items from list c# condition
C#
0 vote282 views1 answer
C# minimise form
C#
0 vote332 views2 answers
Run a command line from vb.net app
C#
1 vote305 views1 answer
Wpf restart application c#
C#
0 vote304 views1 answer
Cannot implicitly convert type 'void' to 'system.eventhandler'
C#
0 vote330 views2 answers
Array of array
C#
1 vote322 views1 answer
How refresh just one table in laravel by terminal
C#
0 vote285 views1 answer
C# paste from clipboard
C#