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 vote183 views1 answer
Asp.net c# set session timeout
C#
1 vote179 views1 answer
C# remove accents
C#
1 vote339 views1 answer
How to detect when a player move in unity
C#Unity
0 vote191 views1 answer
Process start web document
C#
1 vote184 views1 answer
Unity Bullet script
C#
0 vote201 views1 answer
Encode pdf file to base64 c#
C#
0 vote184 views1 answer
Unity SceneTemplatePipeline
C#
0 vote192 views1 answer
C# please build the project and retry
C#
1 vote169 views1 answer
Linq query select where c#
C#
0 vote183 views1 answer
Display none asp.net
C#