Export To Excel and Close Window without Prompt

[Mike]

I have a webpage that has a RadGrid on it and when the page is opened I create an excel attachment using memory stream and send it in an email, then close the window. 

This all works great, I even don't show a prompt to close the window. 

I firmly beleive it has to do with this setting, OpenInNewWindow.  But when I do that

RadGrid Grid1 = (RadGrid)Page.Master.FindControl("Main").FindControl("RadGrid1");
Grid1.ExportSettings.OpenInNewWindow = true;

However, at the bottom of the page there is a dialog to Open, Save or Cancel. 
How can I disable this prompt? 

I have attached images from IE 9 and FireFox 11.

One trick I have seen and it works is to simply create a new html page and have a Redirect to that page at the end of the export that only has a window.close() in the JavaScript.

[Kostadin]

Hi Michael,

Another possible solution is to redirect to the same page. The following code snippet demonstrates the usage of FileStream and after it finished the page is reloaded again.

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
    string path = Server.MapPath("~/MyFile.xls");
    using (FileStream fs = File.Create(path))
    {
        Byte[] info = System.Text.Encoding.Unicode.GetBytes(e.ExportOutput);
        fs.Write(info, 0, info.Length);
    }
    Response.Redirect(Request.Url.ToString());
}

All the best,
Kostadin
the Telerik team

[ArtiCut]

The command  " Response.Redirect(Request.Url.ToString());" redirect to the page,

but the data at the radGrid is empty - the parameters at the page not saved. It's a problem...

 

How can I come back to the page, but the parameters and the data should remain?

or How  can I export to excel and prevent the following message to appear without redirect to the page?

[Daniel]

Hello,

Please refer to my answer in the following thread:
Export to pdf and save programmatically

As to the other question, I'm not sure what parameters are lost in your code, but if you provide more details I may be able to help.

Regards,
Daniel
Telerik by Progress