http://192.168.40.8/gmm/exportexcel3.asp
导出方法很简单:
Response.ContentType="application/vnd.ms-excel"
正常的结果应当如下:
颜色ID | 颜色 |
E13929 | E13929 浅黑 #A2AH |
001 | 001 U WHITE白 |
001BLAC | 001 BLACK黑007 |
001BLACK | 001 BLACK007黑 |
001GOLD | 001GOLD |
001WHIT | KWHITE601白 |
001WHITE | 001白色 |
002 | 02黑299 |
002BLA | 002 黑007 |
002BLACK | 002BLACK 黑 007 |
002黑/白 | 黑/白 |
003 | 白003 |
004 | 彪马红004 |
006BLACK | 006BLACK黑007 |
007CHARC | 007CHARCOAL深灰000 |
007KBLAC | 007黑 |
01 | 01 BLACK 299黑 |
010WHITE | 010白 |
011BLITH | 011快活篮 |
011POWER | 011力量绿 |
011VIBRA | 01光黄 |
013DAND | 013鲜黄 |
但是导出后得到的结果很码很乱码。
奈ID | 奈 |
E13929 | E13929 풍붚 #A2AH |
1 | 001 U WHITE겜 |
001BLAC | 001 BLACK붚007 |
001BLACK | 001 BLACK007붚 |
001GOLD | 001GOLD |
001WHIT | KWHITE601겜 |
001WHITE | 001겜 |
2 | 02붚299 |
002BLA | 002 붚007 |
002BLACK | 002BLACK 붚 007 |
002붚/겜 | 붚/겜 |
3 | 겜003 |
4 | 깅쯩븐004 |
006BLACK | 006BLACK붚007 |
007CHARC | 007CHARCOAL뿍000 |
007KBLAC | 007붚 |
1 | 01 BLACK 299붚 |
010WHITE | 010겜 |
011BLITH | 011우삶은 |
011POWER | 011제좆쫄 |
011VIBRA | 01밟뼝 |
013DAND | 013銶뼝 |
有碰到过类情况的朋友吗?
这里把所有的代码都贴出来先:
<!--#include file="Gmmconn.asp"-->
<HTML>
<HEAD>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
//乱码的问题是在头部编码问题已搞定了。
</HEAD>
<BODY>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql= "select top 100 * from dictcolor"
rs.Open sql,conn,1,1
%>
<%Response.ContentType="application/vnd.ms-excel" %>
<table BORDER= "1 " BGCOLOR= "#FFFFFF " CELLSPACING= "0 " align= "left " width= "640 ">
<tr>
<td valign= "top " align= "center " bgcolor= "#C5F8FA "> <font size= "2 " color= "#000000 "> 颜色ID </font> </td>
<td valign= "top " align= "center " bgcolor= "#C5F8FA "> <font size= "2 " color= "#000000 "> 颜色 </font> </td>
</tr>
<%
On Error Resume Next
rs.MoveFirst
do while Not rs.eof
%>
<tr>
<td ALIGN= "left " valign= "top ">
<font size= "2 " color= "#000000 ">
<%=rs("colorID") %>
</font> </td>
<td ALIGN= "left " valign= "top ">
<font size= "2 " color= "#000000 ">
<%=rs("color") %>
</font> </td>
</tr>
<%
rs.MoveNext
loop
set rs=nothing
%>
</table>
</BODY>
</HTML>