Asp.Net Core 5 - Excel import and Export functionalities

Рет қаралды 18,754

3 жыл бұрын

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/mohamadlawand087/v...
Dotnet SDK: dotnet.microsoft.com/download
Vs Code: code.visualstudio.com/
Let us connect:
🌍 My website - mohamadlawand.com
📸 Instagram - / mohamadlawand087
🐦 Twitter - / moe23
♯ Github - github.com/mohamadlawand087
🎫 LinkedIn - / mlawand
💥 LinkTree - linktr.ee/mohamadlawand
Gear I use (affiliate link): amzn.to/3EbT8Jw
Support my work:
/ mohamadlawand
www.buymeacoffee.com/mohamadl...
Hire Me:
transactions.sendowl.com/prod...
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 hello@mohamadlawand.com.
#excel #dotnet #aspnetcore #beginner #stepbystep #dotnet5

Пікірлер: 18

@vincealfredperez1444 3 жыл бұрын

Great examples of functionalities

@salmonbekkomilov3877 Жыл бұрын

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

@mansourmohammadi8040 2 жыл бұрын

Thank you a lot

@ahmedmohamed-ti9mc 3 жыл бұрын

Thank You very much

@hamseabdi9025 2 жыл бұрын

Thanks for you.

@pratikparmar346 Жыл бұрын

Thank you so much...

@nabilaabdo7296 3 жыл бұрын

👍👍👍👍👍

@OAPSOLUTIONS 2 жыл бұрын

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!

@ramashankar2750 3 жыл бұрын

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

@tookay5 Жыл бұрын

code not on github link.

@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

@hazemkerret2772 3 жыл бұрын

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 3 жыл бұрын

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.