how to export .xlsx file C# ASP.NET MVC razor

Question

I would like to export data to a .xlsx file, but I can only seem to export to .xls.

What's the easiest way to export a .xlsx file?

This is the code I use to export to a .xls file:

GridView gv = new GridView();
gv.DataSource = listCatalogue.ToList();
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=Catalogue.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();

nsgocev · Accepted Answer · 2014-07-31 07:11:42Z

8

You can use an external library like EPPlus.

Taken from the EPPlus documentation:

 private void DumpExcel(DataTable tbl)
        {
            using (ExcelPackage pck = new ExcelPackage())
            {
                //Create the worksheet
                ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Demo");

                //Load the datatable into the sheet, starting from cell A1. Print the column names on row 1
                ws.Cells["A1"].LoadFromDataTable(tbl, true);

                //Format the header for column 1-3
                using (ExcelRange rng = ws.Cells["A1:C1"])
                {
                    rng.Style.Font.Bold = true;
                    rng.Style.Fill.PatternType = ExcelFillStyle.Solid;                      //Set Pattern for the background to Solid
                    rng.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(79, 129, 189));  //Set color to dark blue
                    rng.Style.Font.Color.SetColor(Color.White);
                }

                //Example how to Format Column 1 as numeric 
                using (ExcelRange col = ws.Cells[2, 1, 2 + tbl.Rows.Count, 1])
                {
                    col.Style.Numberformat.Format = "#,##0.00";
                    col.Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
                }

                //Write it back to the client
                Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                Response.AddHeader("content-disposition", "attachment;  filename=ExcelDemo.xlsx");
                Response.BinaryWrite(pck.GetAsByteArray());
            }
        }

edited Jul 31, 2014 at 7:11

answered Jul 31, 2014 at 4:23

nsgocev

4,47030 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3894065 Over a year ago

can you explain more?

Christian Sauer Over a year ago

@user3894065 Can you read the documentation of epplus? Otherwise, the code of nsgocev is well written and understandable#

nsgocev Over a year ago

@ChristianSauer I added the code after the OP requested more explanations :)

Collectives™ on Stack Overflow

how to export .xlsx file C# ASP.NET MVC razor

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related