高分求教!!!!!

[xiaodingdang_22]

<form name="form1" method="post" action="xx">
<!--#include file="conn.asp" -->
<%
Recall=request("Recall")
Diagnostic=request("Diagnostic")

if Recall<>"" then
if Recall="Related Recall(OAT)" then
%>
<style type="text/css">
<!--
.STYLE3 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
.STYLE4 {font-size: 12px}
-->
</style>

<table width="100%" border="1" cellspacing="0">
<tr align="center">
<td width="34%"><span class="STYLE4"></span> </td>
<td width="30%"><span class="STYLE3">Average</span></td>
<td width="36%"><span class="STYLE3">Count</span></td>
</tr>
<tr align="center">
<td><span class="STYLE3">Recall</span></td>
<td><span class="STYLE3">
<label>
<input type="text" name="textfield" >
</label>
</span></td>
<td><span class="STYLE3">
<label>
<input type="text" name="textfield2">
</label>
</span> </td>
</tr>
<tr align="center">
<td><span class="STYLE3">Message Elements</span></td>
<td><span class="STYLE3">
<label>
<input type="text" name="textfield3" />
</label>
</span></td>
<td><span class="STYLE3">
<label>
<input type="text" name="textfield6">
</label>
</span></td>
</tr>
</table>
<%
else
if Recall="Related Recall(ADV2.0)" then
%>
<table width="100%" border="1" cellspacing="0">
<tr>
<td width="34%"><span class="STYLE4"></span></td>
<td width="30%"><span class="STYLE3">Average</span></td>
<td width="36%"><span class="STYLE3">Count</span></td>
</tr>
<tr align="center">
<td><span class="STYLE3">Recall</span></td>
<td><span class="STYLE3">
<label>
<input type="text" name="textfield13">
</label>
</span></td>
<td><input name="textfield25" type="text"></td>
</tr>
</table>
<%
else
response.write "error"
end if
end if
else
response.write "none"
end if
%>
<%

if Diagnostic <>"" then
if Diagnostic="Main Idea/Watchability/Likability" then
%>


<table width="100%" border="1" cellspacing="0">
<tr>
<td width="34%"> </td>
<td width="30%">Average</td>
<td width="36%">Count</td>
</tr>
<tr>
<td>Message Elements</td>
<td><label>
<input type="text" name="textfield4">
</label></td>
<td><label>
<input type="text" name="textfield5">
</label></td>
</tr>
<tr>
<td>Strategic Benefit</td>
<td><label>
<input type="text" name="textfield7">
</label></td>
<td><label>
<input type="text" name="textfield8">
</label></td>
</tr>
<tr>
<td>Copy Strategy Message</td>
<td><label>
<input type="text" name="textfield9">
</label></td>
<td><label>
<input type="text" name="textfield10">
</label></td>
</tr>
</table>
<%
else
if Diagnostic="AD Rating" then
%>


<table width="100%" border="1" cellspacing="0">
<tr>
<td width="34%">Attributes</td>
<td width="30%">Average</td>
<td width="36%">Count</td>
</tr>
<tr>
<td> </td>
<td><label>
<input type="text" name="textfield11">
</label></td>
<td><label>
<input type="text" name="textfield12">
</label></td>
</tr>
</table>
<%
else
if Diagnostic="AD Rating for Model Recall" then
%>

<table width="100%" border="1" cellspacing="0">
<tr>
<td width="34%"> </td>
<td width="30%">Average</td>
<td width="36%">Count</td>
</tr>
<tr>
<td>Everyone can notice or remenber</td>
<td><label>
<input type="text" name="textfield14">
</label></td>
<td><label>
<input type="text" name="textfield15">
</label></td>
</tr>
<tr>
<td>Most of them can notice or remenber</td>
<td><label>
<input type="text" name="textfield17">
</label></td>
<td><label>
<input type="text" name="textfield16">
</label></td>
</tr>
</table>
<%
else
if Diagnostic="Likes" then
%>
<table width="100%" border="1" cellspacing="0">
<tr>
<td width="34%"> </td>
<td width="30%">Average</td>
<td width="36%">Count</td>
</tr>
<tr>
<td>FAVORABLE COMMENTS</td>
<td><label>
<input type="text" name="textfield18">
</label></td>
<td><label>
<input type="text" name="textfield19">
</label></td>
</tr>
<tr>
<td>MESSAGE ELEMENTS</td>
<td><label>
<input type="text" name="textfield20">
</label></td>
<td><label>
<input type="text" name="textfield21">
</label></td>
</tr>
</table>
<%
else
if Diagnostic="Dislikes" then
%>
<table width="100%" border="1" cellspacing="0">
<tr>
<td width="34%"> </td>
<td width="30%">Average</td>
<td width="36%">Count</td>
</tr>
<tr>
<td>UNFAVORABLE COMMENTS</td>
<td><label>
<input type="text" name="textfield22">
</label></td>
<td><label>
<input type="text" name="textfield23">
</label></td>
</tr>
<tr>
<td>MISCELLANEOUS UNFAVORABLE COMMENTS</td>
<td><label>
<input type="text" name="textfield26">
</label></td>
<td><label>
<input type="text" name="textfield24">
</label></td>
</tr>
<tr>
<td>UNCONVINCING/NOT EFFECTIVE/NOT WANT TO TRY</td>
<td><label>
<input type="text" name="textfield27">
</label></td>
<td><label>
<input type="text" name="textfield28">
</label></td>
</tr>
</table>

<%
else
response.write "error"
end if
end if
end if
end if
end if
else
response.write "none"
end if%>


<table width="100%" border="0">
<tr align="center">
<td><label>
<input type="submit" name="Submit" value="excel">
</label></td>

</tr>
</table>
</form>
</body>
</html>
怎样可以点击按钮后使不隐藏的表格中的数据倒出成EXCEL.急!!谢谢!

[hardways]

帮顶！

[hardways]

http://www.fyasp.com/Html/Article/asp/aspyy/1397.html

[xiaodingdang_22]

有高手在吗?

[hardways]

帮顶！

[xiaodingdang_22]

DING

[xiaodingdang_22]

up

[gump21]

不就是按一个按钮，将参数传递到临一个asp页面，在这个页面做好数据表。再加上
<%
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "inline; filename = 库存明细.xls"
%>

[xiaodingdang_22]

顶

[mataofq]

数据倒出成EXCEL????
//见好多人问到这样的问题，结果都是不果而终，看来要去研究一下啊

[xiaodingdang_22]

高手们其实说白了就是将HTML页面中的数据转成EXCEL!有会的吗?

[beyond_jsq]

QQ24996521
想实现这个功能就加。

[chunchun_11]

UP

[xiaodingdang_22]

up