Thanks for the nice post, I have samll query, my webpage where the GridView has master page and because of this I am getting an error syaing that place inside a webform with runat=server error.
Could you please hlep to resolve this? and also could you please send the code of clearcontrols function code in VB
I had this same problem with IE being unable to find the file and it took me a couple of hours to figure out that I had disabled DDE in excel to prevent all my excel spreadsheets from opening up in the same window. In Office 2007 click on Excel Options
then under Advanced-->General there is an "Ignore other applications that use Dynamic Data Exchange (DDE)" I had that option checked. As soon as I unchecked it, the excel opened right up on the next web call.... Now to get to the formatting.
srinmal
Member
13 Points
13 Posts
Re: How To: Make "Export to Excel" always open excel in a separate Window
Sep 05, 2008 07:43 PM|LINK
Hello Ryan,
Thanks for the nice post, I have samll query, my webpage where the GridView has master page and because of this I am getting an error syaing that place inside a webform with runat=server error.
Could you please hlep to resolve this? and also could you please send the code of clearcontrols function code in VB
Noonway
Member
27 Points
10 Posts
Re: How To: Make "Export to Excel" always open excel in a separate Window
Mar 24, 2009 02:41 PM|LINK
I had this same problem with IE being unable to find the file and it took me a couple of hours to figure out that I had disabled DDE in excel to prevent all my excel spreadsheets from opening up in the same window. In Office 2007 click on Excel Options then under Advanced-->General there is an "Ignore other applications that use Dynamic Data Exchange (DDE)" I had that option checked. As soon as I unchecked it, the excel opened right up on the next web call.... Now to get to the formatting.
bpnanu
Member
6 Points
3 Posts
Re: How To: Make "Export to Excel" always open excel in a separate Window
Jun 14, 2010 12:15 PM|LINK
may I know how to open a excel in a new window without prompting for SAVE or OPEN button
if I click on Export to Excel button, it asks me if I want to open that file or save it
I want to open it without asking me??
hoping for your answer
thanx in advance
bpn
smirnov
All-Star
24614 Points
4192 Posts
Re: How To: Make "Export to Excel" always open excel in a separate Window
Jun 14, 2010 01:33 PM|LINK
You probably have specified the header content-disposition to "attachment" which forced the browser to open Open/Save Dialog:
Response.AddHeader("content-disposition", "attachment;filename=import.xls")Use "inline" keyword instead
Response.AddHeader("content-disposition", "inline;filename=import.xls")bpnanu
Member
6 Points
3 Posts
Re: How To: Make "Export to Excel" always open excel in a separate Window
Jun 15, 2010 05:35 AM|LINK
thanx for ur time
but I have used an aspx page to display excel using:
<%@ Page Language="C#" AutoEventWireup="true" ContentType="application/vnd.ms-excel" CodeFile="Report4Agent_Excel.aspx.cs" Inherits="Reports_UI_Report4Agent_Excel" %>
and it asks whether to save or open
i just want to open the excel without prompting
hope u understood my problem
thanx in advance