Hi All,

 

i am working on a requirement where excel has to be generated on click of a button.

below is the code which will be executed on button click.

 strExcel contains the whole data in HTML layout

   Response.Clear()
            Response.AddHeader("content-disposition", "filename=Forecast.xls")
            Response.Charset = ""
            Response.Cache.SetCacheability(HttpCacheability.NoCache)
            Response.ContentType = "application/vnd.xls"
            Response.Write(strExcel)
            Response.End()
           
           
<asp:UpdatePanel>
  <ContentTemplate>
    <asp:Button ID="btnDownload" runat="server" Text="Download to XLS" Width="150px" />
  </ContentTemplate>
  <Triggers>
      <asp:AsyncPostBackTrigger ControlID="btnViewForeCast" EventName="Click" />
       <asp:PostBackTrigger ControlID="btnDownload" />
  </Triggers>
 

the issue is after user clicks on download to excel, the excel is replacing the webpage. it is supposed to open in excel.

however this issue is coming up in systems which have MS Office 2003 , in systems with Office 2007 this is getting opened in  excel.

please suggest me any approach to resolve this issue.

Thanks in Advance :)

 

Use Response.BinaryWrite(buffer in byte[]); or Response.WriteFile("file");

It'll always prompt dialog box to user than ask user what to do? either open directly or save to disk.

And for " Response.BinaryWrite(buffer in byte[]);" this you ahve to pass file as a byte array... so keep in mind ...

And also add this [see bold text]

Response.AddHeader("content-disposition", "attachment; filename=JWordTestFile.xls");