c#(.Net) — Reading data from Excel with ExcelDataReader. (en)

created with xAI

Hello Guys,
The ExcelDataReader library is a super tool that allows you to read data from Excel files even if Excel is not installed on your computer or server.

In this article, I will show you an example of how to read data from Excel in c#(.Net). You can also use it for CSV if you like. You can find more information on the GitHub page.

I’m opening a new Console App Project.

Console App

I write the project name. I click ‘Next’ to proceed.

Configure Project

I choose .NET 8.0. Since I prefer using parentheses. I check the ‘Do not use top-level-statements’ checkbox.

.Net 8.0

We have opened our project. Before diving into the code, I want to show you the Excel file I intend to read.
Since Excel is not installed on my computer I created a test Excel file…