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

Question

how to update excel data in database by using asp.netmvc ? please kindly rply if any one knows

Jignesh Kumar · 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/

Anoop Kumar Sharma · Answer

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.

Amit Mohanty · Answer

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/

Mukesh Nailwal · Answer

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

Vishal Yelve · Answer

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/