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 vote219 views1 answer
VideoPlayer.isPlaying
C#
0 vote261 views1 answer
Dependency Injection Create Scope at constructor
C#
0 vote404 views1 answer
How to set a Printer Port in C# on a specified Printer
C#
0 vote265 views1 answer
Implementing Banner Ads Unity
C#Unity
28 votes238 views2 answers
Asp.net format datetime
C#
0 vote270 views1 answer
Unity mix gradient colors
C#Unity
28 votes236 views2 answers
C# file exist
C#
6 votes232 views2 answers
Play sound unity
C#Unity
0 vote232 views1 answer
Allelrt box wpf
C#
0 vote248 views1 answer
Print arraylist values to console unity
C#