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

8 votes104 views1 answer
C# input integer
C#
0 vote110 views1 answer
How to show process time run c#
C#
0 vote108 views1 answer
Pyautopgui erros
C#
21 votes111 views2 answers
Random.range unity
C#
3 votes110 views5 answers
Justin bieber
C#
4 votes115 views3 answers
C# get username
C#
0 vote111 views1 answer
Largest prime factor of a number
C#
2 votes107 views1 answer
C# Thread Sleep vs Task Delay
C#
0 vote230 views1 answer
How to keep rigidbody2D upright unity
C#Unity
0 vote134 views1 answer
Save string unity
C#