Getting Alert . While Opening a Excel sheet.

Question

Hi... I am generating a report the Data to Excel sheet. The data gets generating but When i am trying to Open the Excel sheet document . shows the alert message like this. The file you are trying to open abc.xls is in different format than specified by the extension. Verify that the file is not corrupted and is from trusted source before openong the file. Do you want to open the file now ?? And than i click Yes it's opening No issues Response.ContentType = application/vnd.ms-excel; Response.AddHeader(Content-dispositionattachment;filename=abc.xls) Can any one help me to get rid of this alert message

Naveen Kumar · Answer

This was My code.... protected void btnReportS_Click(object sender EventArgs e) { try { lblResult.Text = string.Empty; Response.Buffer = true; Response.Charset = ; Response.ClearContent(); Response.ContentType = application/vnd.ms-excel; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); Response.AddHeader(content-disposition attachment;filename=Employee Holiday Report +   + DateTime.Now.ToShortDateString() +   + DateTime.Now.ToShortTimeString() + .xls); Response.Write( ); Response.Write( Employee Holiday Report ); Response.Write( Report Generated On:   + drtime +  Date Range:    + hdaterange.Value +  ); Response.Write(  + lblUnmae.Text +  +lblleavestaken.Text+ ); Response.Write(   ); string style = @ .text-02 { mso-number-format:\@; } ; Response.Write(style); gvEmployeeReport.RenderControl(htw); Response.Write(sw.ToString()); Response.Write( ); HttpContext.Current.ApplicationInstance.CompleteRequest(); Response.End(); } catch(Exception Ex) { throw new Exception(Ex.Message); } } public override void VerifyRenderingInServerForm(Control control) { // base.VerifyRenderingInServerForm(control); }

Pradeep Shet · Answer

Hey Naveen Add below line it should work. Response.ContentType = application/vnd.ms-excel; Response.AddHeader(Content-dispositionattachment;filename=abc.xls) ; HttpContext.Current.ApplicationInstance.CompleteRequest(); Response.End(); Try it once and if it solves your problem mark it answered.

biren mohanty · Answer

Can you please tell how many total records you want to displaying.? Because you know excel has maximum limit for for 2007 and 2010 version.

Naveen Kumar · Answer

Even I added the Response.End() method the alert message is displayed.

Pradeep Shet · Answer

Hi Use Response.End(); after adding Adding Header and all. Response.ContentType = application/vnd.ms-excel; Response.AddHeader(Content-dispositionattachment;filename=abc.xls) Response.End(); This will solve your problem of showing popup alert. Hope this solution helps you. If so mark it as answered