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 vote102 views1 answer
C# update control from another thread
C#
3 votes139 views2 answers
Transform.Translate unity
C#Unity
0 vote104 views1 answer
Move files from one folder to another using c#
C#
1 vote104 views2 answers
C# bool to int
C#
4 votes129 views3 answers
How to create a singleton in unity
C#Unity
4 votes103 views7 answers
XML
C#
0 vote107 views1 answer
Code to disable Debug.log
C#
0 vote146 views1 answer
Add float value to ui text in unity
C#Unity
0 vote96 views1 answer
Unity magnetize a 3d object to cursor
C#
20 votes97 views4 answers
Generate random string C#
C#