How to Import Data from Excel File to Database Table Using ASP.NET Core and Entity Framework

[@olegpogorelov5223]

Thank you very much! Finally, thanks to your video tutorial, I understood this topic!)

[@dexcodelab]

You're welcome. Glad it helped!

[@vuThien263]

Tks bro ur video step by step is very easy to understand

[@dexcodelab]

I'm glad it helped you

[@msdhonicoolcaptain]

Thank you Salman, this video is really helpful. I have subscribed your channel.

[@dexcodelab]

You're welcome sir, I'll try to make more helpful videos, and thats for liking and subscribing

[@ekremozafsar2875]

Thank u man keep going!

[@dexcodelab]

You're welcome

[@sangeethalakshmanathilagar9723]

Hi Thank you so much your video is very helpful for me as a beginner in MVC . I have a doubt I want the database to read the null columns and rows also . I tried different codes it is not working and also I want the reader to read from a particular row . For example to start to read the excel file from row 10. Thank you.

[@dexcodelab]

The nuget package used in the video has 2 methods to read excel. If you want to read value of row 10 then go to 17:50 of the video. At 17:50 you can see the sample code by the developers, you have to use method 2. That will copy all values of excel in datatable and feom datatable you can directly access the cell. For you first query i need more information. There should be no issue in reading null values. If you're getting some error please share that as well.

[@pamodpeiris154]

Very good explanation. Short and clear.

[@dexcodelab]

Glad you liked it

[@aliyousef4755]

very organized and clear, Thank you🙏

[@dexcodelab]

Glad it was helpful!

[@namessis]

Amazing thanks for your labor and solution. !!! We are excitedly waiting for content.

[@dexcodelab]

Thankyou for liking the content, will try to upload more helpful content in future

[@myti1617]

that was perfect

[@dexcodelab]

Thankyou sir

[@juliuszhu9123]

nice job! thanks for doing this.

[@dexcodelab]

My pleasure!

[@bipinlal1724]

Very good video, really understood. data can be saved very 👍👍👍👍

[@dexcodelab]

Thank you sir

[@raziuddinmohd]

Nice explanation..very useful

[@dexcodelab]

Thank you sir

[@thecyberhelp1]

Thanku bro this solution is best one

[@dexcodelab]

You're welcome

[@hoangheo2505]

thanks you for tutorial ^^

[@dexcodelab]

You're welcome 😊

[@hieuang79]

Thank you very much!

[@dexcodelab]

You're welcome sir

[@DanishFarhan-wg3xz]

can i use this for core 8?

[@dexcodelab]

Yes you can.

[@MithileshKumar-c1g]

Please make video for bulk insert from excel to sql server like 1m row insert at one click

[@dexcodelab]

That sounds good! I'll keep it in mind for future content.

[@tharun4939]

Is it with the validation too

[@dexcodelab]

Validation of?

[@tharun4939]

@@dexcodelab SQL data types

[@dexcodelab]

Can you please share the exact error?

[@randnas]

How can I import data with more than one file to more than one table??

[@dexcodelab]

First make the html input tag to select multiple files. Second convert IFormFile to List files. Then loop through files and perform import operation on each file.

[@ShanteshManure]

FormatException: Input string was not in a correct format. mainExcelFile.PoNo = Convert.ToInt32(reader.GetValue(1).ToString());

[@dexcodelab]

I think the cell value is not numeric or its either null that why conversion has failed. Create a try catch block to skip the bad row or use int.TryParse method. Incase of bad row you can also put a hardcoded default value like 0 or make a list of all bad rows and at the end you can display data that is not inserted and has errors.

[@bruhmanbruhmanzz]

Can you do a video about export excel file from db?

[@dexcodelab]

I don't promise but i will try

[@Sameyo_Rei]

how to change it to Net core web APi

[@dexcodelab]

Sure, i will try to make a video for this

[@Sameyo_Rei]

@@dexcodelab thank you

[@dexcodelab]

welcome sir, New video with API is uploaded

[@tharun4939]

I am getting an error can you please help me with that error 🙏

[@dexcodelab]

Where are you getting the error?

[@tharun4939]

@@dexcodelab during the database app user creation

[@dexcodelab]

Can you please share the exact error?

[@sunnyafran415]

I can't add import excel file to datagridview then save to database at the same project, you have uploaded two different tutorials ,please give a tutorial import excel file display DataGridView and save to database in same project without migration, please it's urgent.

[@dexcodelab]

Sorry, i have a busy schedule these days, once i will find time i will do it. Do you want it done with db first approach?