Export Excel Question

Guest · Sep 20, 2006

Hi all,

I have a parent page(parent.aspx) which will open different new windows
depending on the user input.

for example,
the new windows are opened using the following code :
window.open('child.aspx', document.userinput.value)

In the child.aspx, the result is rendered as Excel, Word, PDF, etc...
depending on the input parameters from the parent pages.

There is no problem when the user just open 1 pop up window.
However, when the user first open a Excel Window, and then open another
window (Word) , the first window will become blank. Then the result in the
second window
will become the result in first window (Excel).

Thank You.

Guest · Sep 20, 2006

Here are the sample codes.
Parent.html :

<html>
<head>
<script language=javascript>
function OpenWindow()
{
var oWnd = window.open('', document.frmOption.selOption.value);
document.frmOption.target = document.frmOption.selOption.value;
document.frmOption.submit();

}
</script>
</head>
<body>
<form id=frmOption name=frmOption method=post action="child.aspx">
<select id=selOption name=selOption>
<option value=1>Excel</option>
<option value=2>Word</option>
</select>
<input type=button value="Open Window" onclick="OpenWindow()">
</form>
</body>
</html>

Put the following code in Child.aspx :
c#

if (Request["selOption"].ToString().Trim() == "1")
{
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition",
"inline;filename=excel.xls");
Response.Write("This is Excel");
}
else
{
Response.ContentType = "application/vnd.msword";
Response.AddHeader("Content-Disposition",
"inline;filename=word.doc");
Response.Write("This is Word");
}
Response.End();

vb.net

if Request("selOption").ToString().Trim() = "1" Then
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition",
"inline;filename=excel.xls")
Response.Write("This is Excel")
else
Response.ContentType = "application/vnd.msword"
Response.AddHeader("Content-Disposition",
"inline;filename=word.doc")
Response.Write("This is Word")
end if
Response.End()

I want to Display Excel As HTML In js	2	Feb 24, 2023
Image shifts to the right when export the page to pdf	4	May 5, 2023
Export to EXCEL Problem	0	Jun 6, 2006
Creating a direct download div link for pdf file	3	Mar 19, 2023
export to excel	1	Mar 12, 2010
Collect Excel Data from Website	5	Apr 30, 2022
Export To Excel - ASP.NET 1.1	1	Mar 15, 2007
Reload Parent page	2	Feb 21, 2005

Export Excel Question

Guest

Guest

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads