how to update excel data in database by using asp.netmvc

prakash killi

4y1.1kASP.NET Core

how to update excel data in database by using asp.netmvc ?

please kindly rply if any one knows

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar3y ago
Accepted answer
Hi Prakash,

Please refer this thread which will help you step by step,

https://www.c-sharpcorner.com/article/read-data-from-excel-file-and-insert-into-database-in-asp-net-mvc/

https://www.c-sharpcorner.com/UploadFile/9c6206/import-data-from-excel-file-to-database-table-in-Asp-Net-mvc/

Incase direct you want to import one time activity then you can use import wizard from SQL server,

https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/
+2
Mukesh Nailwal3y ago
Hello @Prakash,

You can read out this article to understand the topic and easily import excel data into the database. https://www.c-sharpcorner.com/article/how-to-import-data-from-excel-data-into-sql-table/

Let me know if any confusion.

All the best!

Thanks
+2
Anoop Kumar Sharma3y ago
Hi Prakash,

I have already written an article with step by step appraoch on Export and Import Excel file using ClosedXML in ASP.NET MVC. Please refer to the below link

https://www.c-sharpcorner.com/article/export-and-import-excel-file-using-closedxml-in-asp-net-mvc/

I hope this will help you.
+2
Vishal Yelve4y ago
Hi Prakash,

Please refer to my article How To Read Data From An Excel Sheet, In which I have read data from excel and loaded that into a data table.

https://www.c-sharpcorner.com/article/how-to-read-data-from-an-excel-sheet/
+2
Amit Mohanty4y ago
Check the articles

https://www.c-sharpcorner.com/article/import-excel-file-to-sql-table-in-asp-net-mvc/

https://www.c-sharpcorner.com/article/import-excel-data-to-database-using-Asp-Net-mvc-entity-frame/
+2