Problem when downloading .xlsx in Chrome Error: network error

Question

Problem when downloading .xlsx in Chrome Error: network error

Navigation

#1 by (1 votes)

2

When I want to export a list of type IEnumerable from Chrome it gives me an error that says "Error: network error". I try it in Firefox and it's ok, download the file. Someone will know how to solve this, or have an alternative (another method to download the xls?)

 private void ExportXls(IEnumerable list, string NameFile)
        {
            var workbook = new Workbook();
            workbook.Worksheets.Add(new Worksheet("Datos"));
            var worksheet = workbook.Worksheets[0];

            var ws = worksheet;

            ws.GenerateByIEnumerable(list);





            HttpResponse response = System.Web.HttpContext.Current.Response;
            response.Clear();
            response.ContentType = "application/octet-stream";
            response.AppendHeader("Content-Disposition", "attachment; filename=\"" + NameFile + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx" + "\"");
            workbook.Save(response.OutputStream);
            response.Flush();
            response.Close();
            response.End();
        }

c# asp.net-mvc google-chrome excel

asked by Ariel Octavio D'Alfeo 25.01.2018 в 23:09

source

1 answer

Why does it work the same with square brackets and without brackets? How do I fix footer elements?

score 1 · Accepted Answer

I could solve it by taking the response.Close() and changing the response.ContentType = "application/octet-stream" by "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ;

private void ExportXls(IEnumerable list, string NameFile)
        {
            var workbook = new Workbook();
            workbook.Worksheets.Add(new Worksheet("Datos"));
            var worksheet = workbook.Worksheets[0];

            var ws = worksheet;

            ws.GenerateByIEnumerable(list);





            HttpResponse response = System.Web.HttpContext.Current.Response;
            response.Clear();
            response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            response.AppendHeader("Content-Disposition", "attachment; filename=\"" + NameFile + "_" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx" + "\"");
            workbook.Save(response.OutputStream);
            response.Flush();
           // response.Close();
            response.End();
        }