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

26 votes295 views3 answers
ModuleNotFoundError: No module named 'requests'
C#
1 vote265 views1 answer
Decimal to string c#
C#
0 vote324 views1 answer
Unity unfreeze position in script
C#Unity
0 vote277 views1 answer
ExecuteResultAsync
C#
2 votes329 views2 answers
Casting string to enum type
C#
3 votes300 views1 answer
Unity pause animator
C#Unity
0 vote276 views1 answer
Unity mix gradient colors
C#
48 votes291 views6 answers
C# remove last character from string
C#
4 votes293 views3 answers
Unity singleton
C#
10 votes292 views6 answers
C# string to enum
C#