Download file as excel sql data mvc

Choose Class and it will give you the dialog Window, where you can provide the name of the class. Thus, I am going to add the following entity classes and database context classes. View All. Mukesh Kumar Updated date Jul 26, Next Recommended Reading. Visual Studio Vs Visual Studio Getting Started With. But suppose, we have to download from more than one table; or we have to download to different sheets in an Excel file; or if we have some already-existing format in an Excel file and we just have to update the fields in sheets; then it's very difficult.

However, now I have a solution. First, let's create 3 tables in the database. Now, we have to add the tables in my MVC application. First, we have to display records for understanding purpose. So for that I am using partial view to display records of 3 tables in separately in one page. Now we can see the output below but before that we have to create a view page for calling all 3 partial views. Now we can see the output Step4. You can't save the excel directly to the client's pc.

What you can do is to save the excel to the server and share it with clients to download. You can modify your ExportToExcel method to return the generated file name which you'll use to open your excel file. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Export excel file from database through browser using mvc Ask Question.

Asked 5 years, 11 months ago. Active 5 years, 10 months ago. Viewed 1k times. Application excel; Microsoft. Workbook worKbooK; Microsoft. Application ; excel.