This is a migrated thread and some comments may be shown as answers.

Excel output to Response Stream

2 Answers 42 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

David asked on 28 Feb 2013, 04:14 PM

error.png

I get a strange error when i try to output an excel report book to a response stream. This code was working perfectly before cant figure out why telerik is behaving strangely. We are using Telerik reporting 4.0.10.310.
What is wrong... my intention is the excel file must download to the client on click of a button.
Here when i click on the save and open the file from the local drive the xls is perfect.
but when i click on open .... it downloads a copy of the aspx page where it says the format is different or the file is corrupted.
This is my code
I found if i remove the multiview and the view the same exact code works perfectly. I have another form where this kind of set up works(multiview-view-updatepanel). I dont understand the difference.
What is wrong?

Page has a buttion inside Multiview->view->updatepanel

<asp:MultiView ID="mvwReports" runat="server">

<asp:View ID="vwTotalCostOfOwnership" runat="server">

<asp:UpdatePanel runat="server" ID="UpdatePanel1" UpdateMode="Conditional" RenderMode="Inline">

<asp:ImageButton ID="imgBtnExcel" runat="server" CausesValidation="false" ToolTip="Excel"

Visible="true" AlternateText="Excel" Enabled="true" ImageUrl="~/App_Themes/WebBlue/images/excel_icon.gif"

OnClick="imgBtnExcel_OnClick" />

</ContentTemplate>

<asp:PostBackTrigger ControlID="imgBtnExcel" />

</Triggers>

</asp:UpdatePanel></div>

</asp:View>

</asp:MultiView>

Code behind

protected void Page_Load(object sender, EventArgs e)

{

mvwReports.ActiveViewIndex = 0;

}

protected void imgBtnExcel_OnClick(object sender, EventArgs e)

{

Response.Clear();

Response.ContentType = "application/vnd.ms-excel";

Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);//(HttpCacheability.Private);

Response.Expires = -1;

Response.Buffer = true;

Response.AddHeader("Content-Disposition", string.Format("{0};FileName=\"{1}\"",

"attachment","test" + ".xls"));

Response.TransmitFile("e:\\temp\\excel\\test.xls");

HttpContext.Current.ApplicationInstance.CompleteRequest();

}

Excel output to Response Stream

2 Answers, 1 is accepted