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 vote131 views1 answer
Force asp.net https
C#
25 votes141 views3 answers
If get key down unity
C#
0 vote145 views1 answer
Install Mono project on Ubuntu 20.04
C#
0 vote153 views1 answer
How create two database conction in laravel
C#
0 vote147 views1 answer
Serenity get id from insert repository
C#
0 vote135 views1 answer
Function to accept interger
C#
0 vote137 views1 answer
Battle.net
C#
0 vote136 views1 answer
Blazor webassembly .net standard 2.1
C#
0 vote189 views1 answer
Cs close opened form when reopened
C#
2 votes137 views2 answers
Unity left mouse button
C#