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 vote256 views1 answer
C# drive info
C#
0 vote258 views1 answer
C# read all lines from filestream
C#
0 vote287 views1 answer
C# Calculate MD5 Checksum For A File
C#
106 votes438 views6 answers
C# get random integer
C#
0 vote261 views1 answer
Mvc input number rounding
C#
0 vote352 views2 answers
Unity timer
C#
0 vote288 views1 answer
C# usermanager update user
C#
0 vote259 views1 answer
Create instance of class given class name string c#
C#
1 vote259 views1 answer
Unity check if a animator parameter trigger is activated
C#
2 votes291 views1 answer
Unity default rotation
C#Unity