Asp.Net Core 5 - Excel import and Export functionalities

In this video we will cover how we can import and export Excel files in ASP.Net Core 5
So what we will cover today:
- Ingredients
- Coding :)
Source Code:
github.com/moh...
Dotnet SDK: dotnet.microso...
Vs Code: code.visualstu...
Let us connect:
🌍 My website - mohamadlawand.com
📸 Instagram - / mohamadlawand087
🐦 Twitter - / moe23
♯ Github - github.com/moh...
🎫 LinkedIn - / mlawand
💥 LinkTree - linktr.ee/moha...
Gear I use (affiliate link): amzn.to/3EbT8Jw
Support my work:
/ mohamadlawand
www.buymeacoff...
Hire Me:
transactions.s...
WHO AM I:
I'm Mohamad, a Enterprise Architect working in Manchester, UK. I make videos about web, cloud, desktop and mobile development.
GET IN TOUCH:
If you’d like to talk, I’d love to hear from you. Tweeting @moe23 directly will be the quickest way to get a response, but if your question is very long, feel free to email me at [e-mail].
#excel #dotnet #aspnetcore #beginner #stepbystep #dotnet5

[@vincealfredperez1444]

Great examples of functionalities

[@salmonbekkomilov3877]

Thanks much for your effort. Really liked the way you explained functionalities. Good job!

[@pratikparmar346]

Thank you so much...

[@tookay5]

code not on github link.

[@ramashankar2750]

Can this not be source generated using a json schema + file name, that would be great lesson.

[@hivoltech]

I have a FK of VendorId that is an Int , how do you parse the ToSring(); to accept the Int... .Value?.ToString(int.Parse(vendorId)); doesnt seem to work Thanks

[@abdulhabdulroof5215]

Hi Mohammed I have a question what about the MemoryStream() how is it Flushed ? Is it ok not to dispose it

[@OAPSOLUTIONS]

Hi Mohamad. I have a question, please.
¿How I could to use this example for a method [HttpPost] with webapi .Netcore 6?
The data of file must copy into table in database sql server. Thanks!

[@mansourmohammadi8040]

Thank you a lot

[@mohamedhassane5039]

hello me i want to import and compare the file with the table of my db and serrialise the contain of the excel file to my db file and then save it

[@hazemkerret2772]

Hi, Thank you very much! I have question for you please. I have one field dataType: date, why when i export it it's give wrong format. it's showing only number..??

[@MohamadLawand]

Hi Hazem, Thank you for your question.
You will need to update the formating for that cell to display dates. Or once the sheet is generated you can update the cell format to date.
Something like this columnX.EntireColumn.NumberFormat = "DD/MM/YYYY";
Excel convert date time to timestamp.

[@hamseabdi9025]

Thanks for you.

[@ahmedmohamed-ti9mc]

Thank You very much

[@osmanturk7867]

Hello İ cant send as a parameter to different action my Users . How to print your excel data to screen? can you help me please

[@mohamedelbadawy2764]

what packages did you use ?

[@nabilaabdo7296]

👍👍👍👍👍

[@mahmudx]

Can't read xls file :(