Databases
StackOverflow2013
Postsdbo
POActionMethod to return excel application content
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POActionMethod to return excel application content
    primarykey
    data
    text
    <p>What's the correct method to return application/ms-excel content type from an action method in MVC? </p> <p>I've tried creating a controller action method and passing the controller context, such as;</p> <pre><code>public void ExportToExcel(MyViewModel model, ControllerContext context) { .... build up html or xml excel output in Writer context.HttpContext.Response.Clear(); context.HttpContext.Response.ContentType = "applicaton/vnd.ms-excel"; context.HttpContext.Response.AddHeader(.. etc.); context.HttpContext.Response.Write(Writer.ToString()); context.HttpContext.Response.End(); } </code></pre> <p>When trying to use the controller context as above I get a method or operation not implemented exception when calling any method of the Response object.</p> <p>I've also tried returning a FileResult, FileContentResult and ContentResult action result types which seem to just throw my content to the browser.</p> <p>EDIT: Here's my code for the ExcelResult class;</p> <pre><code>public class ExcelResult : ActionResult { private string _content = String.Empty; public string Content { get { return _content; } set { _content = value; } } public ExcelResult(string content) { this.Content = content; } public override void ExecuteResult(ControllerContext context) { context.HttpContext.Response.Clear(); context.HttpContext.Response.ContentType = "application/vnd.ms-excel"; context.HttpContext.Response.Charset = "iso-8859-1"; context.HttpContext.Response.BufferOutput = true; context.HttpContext.Response.AddHeader("content-disposition", "attachment; filename = exportdata.xls"); context.HttpContext.Response.Write(this.Content); context.HttpContext.Response.End(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMaRk
    1. USMaRk
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POActionMethod to return excel application content
      1. USdan_l
      1. VTFavorite
    2. VO
      singulars
      1. POActionMethod to return excel application content
      1. This table or related slice is empty.
      1. VTUpMod
    1. COTo add to this I have also now implmented a custom ActionResult class called ExcelResult that implements the above code in the ExecuteResult method. This gives the same result, i.e. it justs writes to output to the browser. I've used Fiddler to view the response header data, but it all looks ok?
      singulars
      1. POActionMethod to return excel application content
      1. USMaRk
    2. COShow us your `ExcelResult` code. I have done something similar and it is working for me.
      singulars
      1. POActionMethod to return excel application content
      1. UStwoflower
    3. COAs stated, using the above code in the overridden ExecuteResult() method.
      singulars
      1. POActionMethod to return excel application content
      1. USMaRk
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload