Uploading, Reading and Displaying Excel File using ASP .Net Core

Uploading, Reading and Displaying Excel File using ASP .Net Core
0:00 - Introduction
0:16 - Create Project
1:22 - Create a View
4:46 - Upload File
7:52 - Read Excel File
10:12 - Displaying Data in View
12:08 - no data is available for encoding 1252. for information on defining a custom encoding, see the documentation for the encoding.registerprovider method
13:09 - Final output
BuyMeCoffee
www.buymeacoffee.com/techiebo...
Github
github.com/dexcodelab/ExcelFi...
I have used ASP .Net Core 7 to read and display Excel File using ExcelDataReader nuget package. ExcelDataReader provide 2 methods to read excel file.
Contains solution for "no data is available for encoding 1252. for information on defining a custom encoding, see the documentation for the encoding.registerprovider method."

[@KevinMoralesP]

This code allow to save on database?

[@dexcodelab]

No sir, it only reads the excel file and display it.

[@KevinMoralesP]

@@dexcodelab Thanks!, if You have time could You add feature to save into database using EF Netcore 7?, 🙃

[@dexcodelab]

@@KevinMoralesP Sure Sir, It will be uploaded soon

[@dexcodelab]

@@KevinMoralesP I have created and uploaded the tutorial you requested. I hope you will find it helpful.

[@KevinMoralesP]

@@dexcodelab thanks so much!!! I Will see now

[@sunnyafran415]

Is it possible to do a project without entity framework and without migration? It would be very helpful if possible.
Please in details..

[@dexcodelab]

You can use ADO.NET and write sql queries in your c# code to insert data in database.

[@sunnyafran415]

is it possible this excel file display gridview and store database (without EF and migration)

[@dexcodelab]

Yes you can do it by using ADO.NET (you will be writing sql queries in this case)

[@sunnyafran415]

If you have time could you please add feature to save to database without EF and without migration (dynamic excel file not static like this tutorial). Please!

[@dexcodelab]

Ok sir I will try