Update ASP.NET page after Excel Export.

Question

I'm using Response.Write, Response.End to export to Excel/Word/csv. Is there a way to do this and also be able to change text on the page at the same time? For example, I have a controls within an UpdatePanel which I want to make visible/invisible.

Answer 1

Update your page via the AJAX action and, in the process, write out some javascript that calls a separate page/handler that does the actual export.

 if (exporting)
 {
     string cacheID = Guid.NewGuid().ToString();
     Session[cacheID] = ...data or query to export...
     ScriptManager.RegisterStartupScript(Page,
             Page.GetType(),
             cacheid,
             "window.location = '/download.ashx?cacheid=" + cacheID + "';",
             True);
 }