Write causes warning that the file is corrupt when trying to open it in Excel

Mar 9, 2015 at 4:03 PM
I am trying to generate the Simple Excel file using the plugin in ASP.Net with following Code.

The file gets generated successfully, however, after downloading when user open the file it gets a warning message indicating the file is corrupt, do you want excel to fix it ? How do I remove this message ? Below is my code.

private void CreateExcel()
    {
        using (pck = new ExcelPackage())
        {
            MemoryStream memory = new MemoryStream();

            String tmpFile = Path.GetTempFileName();
            FileStream liveStream = new FileStream(tmpFile, FileMode.Create, FileAccess.ReadWrite);

            pck.Load(liveStream);
            //Create the worksheet
            ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Log");

            ws.Cells["A1"].Value = "Test";

            //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());
        }
    }


When I checked the details of the fix that Excel is performing, I found below XML

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error036720_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\ipatel\Downloads\ExcelDemo (1).xlsx'</summary>-<additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo></recoveryLog>
Editor
Mar 9, 2015 at 4:12 PM
Please, take a look at this thread and tell us if it work

http://epplus.codeplex.com/discussions/223843
Marked as answer by imran7799 on 3/9/2015 at 9:54 AM
Mar 9, 2015 at 4:54 PM
It works perfectly!!!!!

Thank you very much for a quick response.
Mar 9, 2015 at 4:55 PM
Just copying the answer from the suggested thread.

Call response.clear before send stream back to client.
                Response.Clear();
                Response.AddHeader("content-disposition", "attachment;  filename=file.xlsx");
                Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";                    
                Response.BinaryWrite(pck.GetAsByteArray());
                Response.End();
Marked as answer by imran7799 on 3/9/2015 at 9:55 AM