How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files

READ EXCEL STEP BY STEP WITH EXCEL DATA READER C#
Reading Excel Files in c# was not easy before . But this ExcelDataReader library C# has made reading excel files easy with just few lines of code.
Excel Data Reader - Read Excel files in .NET
Lightweight and fast library written in C# for reading Microsoft Excel files.This c# library help to read excel(.xls,.xlsx) files and convert to desire outputs dataset and json
#ReadExcelFiles #xlxsandxls #StepbyStep

Reading excel file using C# and ExcelDataReader
I want to introduce you in a library that I usually used to read excel file in C#. It’s called ExcelDataReader, it’s lightweight library for reading excel files. I will not discuss more about it, you can just to the github repository for the details about it.
You need to install two nuget packages for this. Right click to References then Manage Nuget Packages. Go to Browse tab and search and install ExcelDataReader and ExcelDataReader.DataSet

How to read an Excel file using C#
The following program illustrates how to open an existing Excel spreadsheet in C# using .NET Framework COM exceldatareader capability. Also you can see how to find Named Ranges in Excel and get the range of occupied cells (Used area) in excel sheet.

How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files
How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files
How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files
How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files
How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files
How to Read Excel File with ExcelDataReader Library in C# visual studio | Open and Read Excel Files

ExcelDataReader,Excel Reading,exceldatareader library,Reading Excel sheet in C#,spread sheet reading in C#,Reading xlsx in C#,Reading Excel sheets in C#,Reading excel File in winforms,How to read excel file in visual studio,Reading Excel with fast library quick,how to Read Excel Data,How to reade xls file in C#,Reading .xlsx file in visual studio,How to read .xlsx File in C#,reading excel files c#,reading excel c#,reading excel in c#,c# reading an excel file

[programmingguruThecoderboy]

Ha Guys Please show some love and support
By Like Subscribe and comment
I desperately need your love and Support.
Subscription costs U nothing
But will helps us reach large viewership

[khadimalivlogs]

awesom c# exceldatareader library tutorial keep it up

[relaxationmeditation]

Excel data reading on c# great tutorial

[Qaimabbass]

Realy helped me alot. Thanks for sharing such informative video

[technologytipsandtricks]

Awesome excel reading tutorial very simple

[topanalysis]

Great excel file reading tutorial love it bro

[AhmadAli-yeve]

Thanks for this video it helped me a lot

[CharwinAmper]

greate video, but how about if the excel have multiple sheets?

[sohailfarooqifarooqi]

great man keep it up you are doing an amazing work

[CentroCoronelAprende]

I can see you have considering the column name as part of the rows. any way to upload with that?

[JensCeddy]

getting that error when i want to open the file:
System.NotSupportedException: "No data is available for encoding 1252. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method."
can you help? it marks the follwing codeline: var reader =

[rameshramagond]

Hi Please help me.
I am getting red line under File.open and FileMode.open and FileAccess.Read and ExcelReader by saying The name does not exist in the current context.

Please tell me how to resolve this.

[ZubairKhan-dunn]

Can you make a video on reading text file

[saulzamarron]

i cant get de Method "AsDataSet" Whyy

[davidrivard]

This method works extremely slow if you're dealing with larger Excel files. Does anyone know a better way?

[yeisondavidgomezrojas]

Alguien sabe como extraer los campos de tipo datetime en la configuración regional que uno necesite?