C# - Server cannot set content type after HTTP headers have been sent

Question

I trying to download SSRS report in excel format from my MVC application.

    Response.Clear();
    Response.Buffer = true;
    Response.Charset = "";
    Response.Cache.SetCacheability(HttpCacheability.NoCache);
    Response.ContentType = "application/vnd.ms-excel";
    Response.AppendHeader("Content-Disposition", "attachment; filename=" + reportName + "." + extension);
    Response.BinaryWrite(result);
    Response.Flush();
    Response.End();

But i am getting this error as -

System.Web.HttpException (0x80004005): Server cannot set content type after HTTP headers have been sent.

I tried changing Response.Buffer to BufferOutput but still getting the same error. What am I missing here?

Ritesh Kulkarni · Accepted Answer · 2020-02-06 12:42:28Z

0

In the code below, i tried to download an excel file as -

        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "";
        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
        Response.AddHeader($"content-disposition", "attachment;filename=" + "{reportFileName}" + ".xlsx");
        using (System.IO.MemoryStream MyMemoryStream = new MemoryStream())
        {
            MyMemoryStream.Write(result, 0 , result.Length);
            MyMemoryStream.WriteTo(Response.OutputStream);
            Response.Flush();
            Response.End();

            return File(MyMemoryStream.ToArray(), "application/octet-stream");
        }

answered Feb 6, 2020 at 12:42

Ritesh Kulkarni

1391 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

C# - Server cannot set content type after HTTP headers have been sent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related