I have created a web app using asp.net MVC 5, that was able too to get an excel file form the client and save it in sql database table. The file is executed on the server and the results are automatically saved in another database table. I am wondering now
how to get the results table form sql and push to the client side an an excel document to be download.
I am wondering now how to get the results table form sql and push to the client side an an excel document to be download.
From your description, I think you want to export data form database table to an excel for user to download. If this is the case you can use ClosedXML to implement it, you can follow the demo in this
link.
If I misunderstanded, please point it out.
Best Regards,
Jiadong Meng
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
Member
4 Points
13 Posts
downloading sql table using asp.net MVC5
Nov 01, 2019 01:18 PM|sk209|LINK
Hello all,
I have created a web app using asp.net MVC 5, that was able too to get an excel file form the client and save it in sql database table. The file is executed on the server and the results are automatically saved in another database table. I am wondering now how to get the results table form sql and push to the client side an an excel document to be download.
Please any idea?
Participant
1320 Points
491 Posts
Re: downloading sql table using asp.net MVC5
Nov 04, 2019 03:31 AM|jiadongm|LINK
Hi sk209,
From your description, I think you want to export data form database table to an excel for user to download. If this is the case you can use ClosedXML to implement it, you can follow the demo in this link.
If I misunderstanded, please point it out.
Best Regards,
Jiadong Meng
Member
4 Points
13 Posts
Re: downloading sql table using asp.net MVC5
Nov 05, 2019 02:11 PM|sk209|LINK
Thank you, it worked.