This is a migrated thread and some comments may be shown as answers.

Export to Excel using MVC

1 Answer 147 Views
This is a migrated thread and some comments may be shown as answers.
Top achievements
Rank 1
Erwin asked on 30 Apr 2010, 03:54 PM

I'm trying to use the Export to Excel functionality, provided by the RadGrid, in conjunction with the MVC framework. (Please ignore this thread if already asked, but every thread pops up when searching for MVC due to the menu bar).

Since it's MVC, the grid is only known by the view. I've tried something in the line of:
grdReport.DataSource = ViewData["Report"]; 
grdReport.ExportSettings.ExportOnlyData = false
grdReport.ExportSettings.IgnorePaging = true
grdReport.ExportSettings.OpenInNewWindow = true

But it only displays the grid, not exporting it. My guess is that at this point, the view is already being rendered, being it too late to change the headers, etc...

Is there a preferred way to export to Excel using MVC? If not, is there a way to export strictly programmatically and catch the export stream, instead of streaming it directly to the response?

Kind regards,

1 Answer, 1 is accepted

Sort by
Telerik team
answered on 06 May 2010, 10:57 AM
Hello Dries,

I recommend you one of the following options:

1) Wrap your RadGrid together with a standard button within a form with runat="server" and then put your code in the click handler of this button.

2) Use the NPOI library as demonstrated in this KB article:
Exporting Grid data to Excel

the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Asked by
Top achievements
Rank 1
Answers by
Telerik team
Share this question