Exporting a HTML Table to Excel from ASP.NET MVC

Question

I am currently working with ASP.NET MVC and I have an action method that displays few reports in the view in table format.

I have a requirement to export the same table to an Excel document at the click of a button in the View.

How can this be achieved? How would you create your Action method for this?

score 7 · Answer 1 · answered Dec 19 '09 at 14:15

7

In your controller action you could add this:

Response.AddHeader("Content-Disposition", "filename=thefilename.xls");
Response.ContentType = "application/vnd.ms-excel";

Then just send the user to the same view. That should work.

answered Dec 19 '09 at 14:15

Dan Atkinson

4

Works, thanks. Just a note, Excel complains about content being in a different format than the extension. – Brian Low Nov 05 '12 at 17:52

score 1 · Answer 2 · edited May 23 '17 at 11:48

1

It's not free, though the most powerful solution I've tried +)

edited May 23 '17 at 11:48

Community

answered Dec 19 '09 at 10:35

score 1 · Answer 3 · answered Dec 19 '09 at 10:45

1

Get data from database using your data access methods in dot net.

Use a loop to get each record.

Now add each record in a variable one by one like this.

Name,Email,Phone,Country
John,john@john.com,+12345,USA
Ali,ali@ali.com,+54321,UAE
Naveed,naveed@naveed.com,+09876,Pakistan

use 'new line' code at the end of each row (For example '\n')

Now write above data into a file with extension .csv (example data.csv)

Now open that file in EXCEL

:)

answered Dec 19 '09 at 10:45

Naveed

1

What if the values contain comma? – Senthil Kumar Jan 19 '11 at 12:24
@tony_le_montana: http://stackoverflow.com/questions/769621/dealing-with-commas-in-a-csv-file – Naveed Jan 19 '11 at 14:47

3 Answers3