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 vote177 views1 answer
Unity public script
C#Unity
0 vote125 views1 answer
MailChimp C# Api calls
C#
0 vote148 views1 answer
C# get random index from list
C#
0 vote167 views1 answer
Git find commits by file path
C#
0 vote115 views1 answer
Xamarin Forms iOS Picker done
C#
1 vote107 views1 answer
C# list object sort alphabetically
C#
0 vote118 views1 answer
C# e-mail send
C#
0 vote120 views1 answer
How to split string into a list ignoring number of spaces c#
C#
0 vote142 views1 answer
Unity can't rename 2d character
C#Unity
33 votes110 views4 answers
How to reload current scene unity
C#