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

1 vote187 views1 answer
{} is this used for code blocks in c#
C#
0 vote205 views4 answers
What are delegates and how to use them c#
C#
18 votes211 views3 answers
Unity find child by name
C#
0 vote200 views1 answer
How to move an object with addforce
C#
1 vote189 views2 answers
Remove items from one list in another c#
C#
0 vote225 views3 answers
ActionExecutingContext result response return objects
C#
0 vote188 views1 answer
C# list item not in another list
C#
1 vote202 views1 answer
C# generic return type in interface
C#
8 votes218 views2 answers
How to sort a list of objects in place
C#
0 vote215 views1 answer
C# deeply related children
C#