Creating Excel file using razor view defined structure

Question

I want to create an .xlsx file not .xls using my razor view string, But it doesn't work here is my code

private ContentResult GenerateExcel<T>(string viewName, T model) where T : class
    {
        var htmlViewRenderer = new HtmlViewRenderer();
        string htmlText = htmlViewRenderer.RenderViewToString(this, viewName, model);
        //  byte[] renderedBuffer;
        Response.ClearContent();
        Response.Buffer = true;

        Response.AddHeader("content-disposition", "attachment; filename=Marklist.xlsx");
        Response.ContentType = "application/ms-excel";
        Response.Charset = "";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);

        Response.Output.Write(htmlText.ToString());
        Response.Flush();
        Response.End();
       return  Content(htmlText,Response.ContentType);

    }

possible duplicate of [What is correct content-type for excel files?](http://stackoverflow.com/questions/2937465/what-is-correct-content-type-for-excel-files) — Pedro.The.Kid, Sep 24 '14 at 09:57
@Pedro.The.Kid thanks but I already tried this but this does not work with XLSX format when i explicitly change extension for xlsx to xls it work — Rutu, Sep 24 '14 at 10:27

score 0 · Answer 1 · answered Oct 01 '14 at 07:45

0

IText-sharp comes with nuget package it helped to create excel i use it and it don't have any issue for xls or xlsx format

answered Oct 01 '14 at 07:45

Rutu

125
2
10

Creating Excel file using razor view defined structure

1 Answers1