Export data to Excel file with ASP NET MVC 4 C is rendering into view

Question

I am having trouble exporting data to Excel  The following seems to render the gridview into my View  instead of prompting the user to open with Excel  which I have installed on my machine    Public ActionResult ExportToExcel                     var products   this Repository Products ToList         var grid   new GridView        grid DataSource   from p in products                       select new                                                   Id   p Id                            Name   p Name                              grid DataBind         Response ClearContent        Response Buffer   true      Response AddHeader  content-disposition    attachment  filename MyExcelFile xls        Response ContentType    application ms-excel        Response Charset           StringWriter sw   new StringWriter        HtmlTextWriter htw   new HtmlTextWriter sw        grid RenderControl htw        Response Output Write sw ToString         Response Flush        Response End         return View  MyView         What am I doing wrong

User · Answer

You can call helper class in any controller    view    Html ActionLink  Export to Excel    Excel      controller Action public void Excel         var model   db GetModel        Export export   new Export        export ToExcel Response  model        helper class public class Export          public void ToExcel HttpResponseBase Response  object clientsList                var grid   new System Web UI WebControls GridView            grid DataSource   clientsList          grid DataBind            Response ClearContent            Response AddHeader  content-disposition    attachment  filename FileName xls            Response ContentType    application excel           StringWriter sw   new StringWriter            HtmlTextWriter htw   new HtmlTextWriter sw            grid RenderControl htw           Response Write sw ToString             Response End

User · Answer

I have done this before  I think you need to remove the ActionResult  Make it a void and remove the return View MyView   this is the solution

User · Answer

I used a list in my controller class to set data into grid view  The code works fine for me   public ActionResult ExpExcl       List lt PersonModel gt  person  new List lt PersonModel gt            new PersonModel    FirstName   Jenny   LastName  Mathew   Age  23       new PersonModel    FirstName   Paul   LastName  Meehan   Age 25           var grid  new GridView       grid DataSource  person     grid DataBind        Response ClearContent       Response AddHeader  content-disposition   attachement  filename data xls       Response ContentType  application excel      StringWriter sw  new StringWriter       HtmlTextWriter htw  new HtmlTextWriter sw       grid RenderControl htw      Response Output Write sw ToString        Response Flush       Response End       return View

User · Answer

using  MemoryStream mem   new MemoryStream            SpreadsheetDocument spreadsheetDocument   SpreadsheetDocument Create mem  SpreadsheetDocumentType Workbook           Add a WorkbookPart to the document      WorkbookPart workbookpart   spreadsheetDocument AddWorkbookPart        workbookpart Workbook   new Workbook            Add a WorksheetPart to the WorkbookPart      WorksheetPart worksheetPart   workbookpart AddNewPart lt WorksheetPart gt         worksheetPart Worksheet   new Worksheet new SheetData             Add Sheets to the Workbook      Sheets sheets   spreadsheetDocument WorkbookPart Workbook AppendChild lt Sheets gt  new Sheets          SheetData sheetData   worksheetPart Worksheet GetFirstChild lt SheetData gt             Add a row to the cell table      Row row      row   new Row     RowIndex   1        sheetData Append row           In the new row  find the column location to insert a cell in A1        Cell refCell   null      foreach  Cell cell in row Elements lt Cell gt                 if  string Compare cell CellReference Value   A1   true   gt  0                  refCell   cell          break                        Add the cell to the cell table at A1      Cell newCell   new Cell     CellReference    A1         row InsertBefore newCell  refCell           Set the cell value to be a numeric value of 100      newCell CellValue   new CellValue  100        newCell DataType   new EnumValue lt CellValues gt  CellValues Number           Append a new worksheet and associate it with the workbook      Sheet sheet   new Sheet               Id   spreadsheetDocument WorkbookPart GetIdOfPart worksheetPart         SheetId   1        Name    mySheet              sheets Append sheet        workbookpart Workbook Save        spreadsheetDocument Close         return File mem ToArray    System Net Mime MediaTypeNames Application Octet   text xlsx

User · Answer

Step 1  View page code   lt input type  button  id  btnExport  value  Export  class  btn btn-primary    gt   lt script gt      document  ready function            btnExport   click function                   window location     Inventory ExportInventory                     lt  script gt    Step 2   Controller Code    public ActionResult ExportInventory                           Load Data             var dataInventory    inventoryService InventoryListByPharmacyId pId               string xml String Empty              XmlDocument xmlDoc   new XmlDocument                 XmlSerializer xmlSerializer   new XmlSerializer dataInventory GetType                  using  MemoryStream xmlStream   new MemoryStream                                  xmlSerializer Serialize xmlStream  dataInventory                   xmlStream Position   0                  xmlDoc Load xmlStream                   xml   xmlDoc InnerXml                             var fName   string Format  Inventory- 0    DateTime Now ToString  s                  byte   fileContents   Encoding UTF8 GetBytes xml                return File fileContents   application vnd ms-excel   fName

User · Answer

I have tried your code and it works just fine  The file is being created without any problem  this is the code I used  it s your code  I just changed the datasource for testing        public ActionResult ExportToExcel                 var products   new System Data DataTable  teste            products Columns Add  col1   typeof int            products Columns Add  col2   typeof string             products Rows Add 1   product 1            products Rows Add 2   product 2            products Rows Add 3   product 3            products Rows Add 4   product 4            products Rows Add 5   product 5            products Rows Add 6   product 6            products Rows Add 7   product 7              var grid   new GridView            grid DataSource   products          grid DataBind             Response ClearContent            Response Buffer   true          Response AddHeader  content-disposition    attachment  filename MyExcelFile xls            Response ContentType    application ms-excel            Response Charset               StringWriter sw   new StringWriter            HtmlTextWriter htw   new HtmlTextWriter sw            grid RenderControl htw            Response Output Write sw ToString             Response Flush            Response End             return View  MyView

[asp.net-mvc] Export data to Excel file with ASP.NET MVC 4 C# is rendering into view

Examples related to asp.net-mvc

Examples related to export-to-excel