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 vote335 views1 answer
How to look around with mouse in unity
C#
0 vote376 views1 answer
How to tell visual studio that you're using unity
C#Unity
2 votes343 views1 answer
Dropdown text mesh pro unity
C#
0 vote354 views2 answers
Mongodb c# batch find
C#
3 votes336 views1 answer
C# get number of files in directory
C#
4 votes353 views1 answer
Shortcut to create property in c#
C#
0 vote372 views1 answer
Classe padre figlio c#
C#
2 votes312 views1 answer
C# previous method
C#
6 votes326 views1 answer
Oncollisionenter unity
C#
0 vote343 views1 answer
Web3.fromWei(eth.getBalance(eth.coinbase));
C#