ansaurus

Question

how to export asp.net MVC detail view data to an excel file?

Answer 1

A:

You could loop through the Keys/Values of your ViewData and generate the excel file (various options mentioned Here) or simply to CSV

But I would recommend rather doing this in the controller and returning a FileResult and not from the ViewData (which I presume you using in your View).

Matthew Hood 2010-04-21 11:02:27

thanks for replay but my requirement is that: i need to display (mvc) employee(view page) that displays a empdetails,on that page i want a one link i.e export to excel.when i click that link i need generate a excel file of empdetails i.e displayed on the employee(view page)

sandeep 2010-04-21 12:52:53

Answer 2

A:

Look at http://blogs.msdn.com/erikaehrli/archive/2009/01/30/how-to-export-data-to-excel-from-an-asp-net-application-avoid-the-file-format-differ-prompt.aspx.

After some experiments I use Open XML SDK 2.0. You can find currently a lot of information how to do this on http://msdn.microsoft.com/en-us/office/aa905545.aspx and http://openxmldeveloper.org/. One more link http://extrememl.codeplex.com/ can be also useful.

Usage of Open XML SDK 2.0 at the first time take a little more time as other ways, but exported files are real Excel files and should not be converted by users. And if you will be have more requirements for the format of produced excel files, you will be able to implement there.

Oleg 2010-04-21 11:08:39

thanks for replay but my requirement is that: i need to display (mvc) employee(view page) that displays a empdetails,on that page i want a one link i.e export to excel.when i click that link i need generate a excel file of empdetails i.e displayed on the employee(view page)

sandeep 2010-04-21 12:53:40

I don't think, that displaying of master/detail views is a problem. One can find a lot of corresponding examples. There are a lot of different ways to do so depends on your requirements. So I answered only on the "export to excel" part of your question. You don't specify in which form do you want to display the information. If you want use some table control, I could recommend jqGrid http://www.trirand.com/blog/?page_id=6. Corresponding master/detail example you can find on http://trirand.com/blog/jqgrid/jqgrid.html, choose "Advanced" on the left side and then "Master Detail".

Oleg 2010-04-21 13:20:50

Answer 3

A:

Depending on the complexity of the page's HTML you might be able to get away with just changing the header type to application/excel. Excel has built in html parsing functionality. I've successfully done this many times a few years back with a DataGrid on a page.

Response.ContentType = "application/excel"
Response.AppendHeader "content-disposition", "attachment: filename=TestExcelFile.xls"

Some details on HTML in excel

used2could 2010-04-21 11:19:36

thanks for replay but my requirement is that: i need to display (mvc)employee(view page) that displays a empdetails,on that page i want a one link i.e export to excel.when i click that link i need generate a excel file of empdetails i.e displayed on the employee(view page)

sandeep 2010-04-21 12:52:22

Answer 4

A:

hey i am not using MVC pattern. I am only using ASP.net 2.0 C#. I am using jqGrid 3.6 version.

I know that there is one property excelexport which need to be set true and we have to add one custom button and the on click of that button i have to call jqgrid.excelExport method. but i have to send on complex object to the page how do i send it?

Rupesh 2010-07-25 17:18:31

ansaurus

tags:

views:

answers:

how to export asp.net MVC detail view data to an excel file?

related questions