asp 怎么导出到EXCEL

[wcfboy1]

想通过一个按钮把数据库的内容导出到EXCEL 怎么实现

[aspgreener]

可以更改输出的文件头。代码如下：
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=analyse"&Date()&".xls"
Response.Charset = "gb2312"
下面就是html代码。

[liudianhalf]

http://community.csdn.net/Expert/topic/4803/4803912.xml?temp=3.466433E-02

[超级大笨狼]

生成HTML，改后缀为XLS

[chenyu112]

关注

[yuanxiaolei]

http://www.piaoy.cn/cxxz.asp

用户名和密码：piaoy

[zhenmeiyisi]

<% '头
Response.ContentType = "application/vnd.ms-excel"
%>

---你想做的事

<% '尾
response.AddHeader "Content-Disposition","attachment;filename=名称.xls"
%>