[knockkneed81]

It's not working.

<FORM METHOD="POST" on click="java script:window.location.href='exporttoexcel.jsp ">
<INPUT NAME="Results"TYPE="submit" VALUE="Export to Excel">
</FORM>

Asp file:

<%
Response.ContentType = "application/x-download"
Response.AddHeader = ("content-disposition","attachment;filename=Test.xls")
%>

[ecuscotty]

knockkneed81, on 15 Oct, 2009 - 10:25 AM, said:

It's not working.

<FORM METHOD="POST" on click="java script:window.location.href='exporttoexcel.jsp ">
<INPUT NAME="Results"TYPE="submit" VALUE="Export to Excel">
</FORM>

Asp file:

<%
Response.ContentType = "application/x-download"
Response.AddHeader = ("content-disposition","attachment;filename=Test.xls")
%>

Hello,

You have a bunch of extra spaces, a missing quote, and the onclick should be on the button, not the form. But really you don't need any javascript to do this. Try...

<FORM METHOD="post" action="exporttoexcel.asp">
<INPUT NAME="Results" TYPE="submit" VALUE="Export to Excel" />
</FORM>

If you need to call a javascript to validate the form you can ...

<script type="text/javascript">
validateExport = function(){
	 // validation code here...
	 if(valid){
		  return true;
	 } else {
		  return false;
	 }
}
</script>
<FORM METHOD="post" action="exporttoexcel.asp" onsubmit="validateExport();">
<INPUT NAME="Results" TYPE="submit" VALUE="Export to Excel" />
</FORM>

... And is "exporttoexcel" an ASP or a JSP page? Looks like it should be ASP?...

[knockkneed81]

ecuscotty, on 15 Oct, 2009 - 11:32 AM, said:

knockkneed81, on 15 Oct, 2009 - 10:25 AM, said:

It's not working.

<FORM METHOD="POST" on click="java script:window.location.href='exporttoexcel.jsp ">
<INPUT NAME="Results"TYPE="submit" VALUE="Export to Excel">
</FORM>

Asp file:

<%
Response.ContentType = "application/x-download"
Response.AddHeader = ("content-disposition","attachment;filename=Test.xls")
%>

Hello,

You have a bunch of extra spaces, a missing quote, and the onclick should be on the button, not the form. But really you don't need any javascript to do this. Try...

<FORM METHOD="post" action="exporttoexcel.asp">
<INPUT NAME="Results" TYPE="submit" VALUE="Export to Excel" />
</FORM>

If you need to call a javascript to validate the form you can ...

<script type="text/javascript">
validateExport = function(){
	 // validation code here...
	 if(valid){
		  return true;
	 } else {
		  return false;
	 }
}
</script>
<FORM METHOD="post" action="exporttoexcel.asp" onsubmit="validateExport();">
<INPUT NAME="Results" TYPE="submit" VALUE="Export to Excel" />
</FORM>

... And is "exporttoexcel" an ASP or a JSP page? Looks like it should be ASP?...

It should be ASP, but which ever works.

[knockkneed81]

knockkneed81, on 16 Oct, 2009 - 04:05 AM, said:

ecuscotty, on 15 Oct, 2009 - 11:32 AM, said:

knockkneed81, on 15 Oct, 2009 - 10:25 AM, said:

It's not working.

<FORM METHOD="POST" on click="java script:window.location.href='exporttoexcel.jsp ">
<INPUT NAME="Results"TYPE="submit" VALUE="Export to Excel">
</FORM>

Asp file:

<%
Response.ContentType = "application/x-download"
Response.AddHeader = ("content-disposition","attachment;filename=Test.xls")
%>

Hello,

You have a bunch of extra spaces, a missing quote, and the onclick should be on the button, not the form. But really you don't need any javascript to do this. Try...

<FORM METHOD="post" action="exporttoexcel.asp">
<INPUT NAME="Results" TYPE="submit" VALUE="Export to Excel" />
</FORM>

If you need to call a javascript to validate the form you can ...

<script type="text/javascript">
validateExport = function(){
	 // validation code here...
	 if(valid){
		  return true;
	 } else {
		  return false;
	 }
}
</script>
<FORM METHOD="post" action="exporttoexcel.asp" onsubmit="validateExport();">
<INPUT NAME="Results" TYPE="submit" VALUE="Export to Excel" />
</FORM>

... And is "exporttoexcel" an ASP or a JSP page? Looks like it should be ASP?...

It should be ASP, but which ever works.

I tried that code and it is opening an empty excel file. I would like the excel file to contain the html table data that's on the webpage.

[ecuscotty]

What is the code for your exporttoexcel.asp file? Does it not contain the table with its data?