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 vote186 views1 answer
In clause db2 c#
C#
11 votes166 views3 answers
Enum get all values C#
C#
-1 vote157 views2 answers
Make endless loop c#
C#
0 vote154 views1 answer
Superscript list
C#
0 vote160 views1 answer
Visual studio console.writeline not showing in output window
C#
0 vote171 views1 answer
Unity lerp position
C#Unity
0 vote191 views1 answer
Print a file from C#
C#
13 votes181 views3 answers
Validate email address
C#
1 vote209 views1 answer
Unity rigid body variable
C#
0 vote289 views1 answer
How to access path position variable in unity
C#