downloading sql table using asp.net MVC5

Question

User507966498 posted

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?

Answer 1

User-17257777 posted

Hi sk209,

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

Answer 2

User507966498 posted

Thank you, it worked.