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
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
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
1170 Points
439 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
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
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.