为什么table里的内容无法导入到excel?

为什么table里的内容无法导入到excel?我有一个页面想导入到excel 但是只导入了table外的内容，table里的内容没有导入。tablede 内容如下：
<table id="tb" bordercolor="#559347" cellspacing="0" cellpadding="1" width="96%" align="center" border="1">
<tr bgcolor="#C7F6B2" align="center">
<td>机构名称</td>
<td>12月</td>
<td>上月订单数</td>
<td>与上月对比</td>
</tr>
<tr bgcolor="#E9FCD9">
<td>海淀</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>魏公村</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>中关村</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr bgcolor="#E9FCD9">
<td>西城</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>西直门</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>德胜门</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>三义庙</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr bgcolor="#E9FCD9">
<td>朝阳</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>朝阳门</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>潘家园</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr>
<td>西坝河</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
<td>0&nbsp</td>
</tr>
<tr bgcolor="Color [MediumAquamarine]">
<td>合计：</td>
<td>1000&nbsp</td>
<td>89&nbsp</td>
<td>911&nbsp</td>
</tr>
</table>用的代码是：Response.ContentType="application/vnd.ms-excel";

解决方案 »

  1.   

    代码是这个：Response.ContentType="application/vnd.ms-excel";
    Response.AddHeader("Content-Disposition" ,"attachement;filename=Sta"+DateTime.Now.ToShortDateString()+".xls");
    Response.ContentEncoding = System.Text.Encoding.UTF7;
      

  2.   

    没了。其他的主要是将数据库里面的内容读出来绑定到页面上的table.绑定后的效果就是我贴出来的那样。
      

  3.   

    代码没有问题.我将你的table copy到aspx中加上这个代码是可以导出的.
      

  4.   

    怎么搞得？郁闷呀。问什么其他内容都可以显示出来唯独table显示不了？哪位老大帮帮忙！
      

  5.   

    要导出的完成页面是这样的：
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <HTML>
    <HEAD>
    <title></title>
    <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
    <meta content="C#" name="CODE_LANGUAGE">
    <meta content="JavaScript" name="vs_defaultClientScript">
    <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
    </HEAD>
    <body leftMargin="0" topMargin="0" marginwidth="0" marginheight="0">
    <form name="Form1" method="post" action="result.aspx" id="Form1">
    <input type="hidden" name="__EVENTTARGET" value="" />
    <input type="hidden" name="__EVENTARGUMENT" value="" />
    <input type="hidden" name="__VIEWSTATE" value="dDwtMTEzNTYwMjUxNDt0PDtsPGk8MT47PjtsPHQ8O2w8aTwxPjs+O2w8dDw7bDxpPDI+O2k8Mz47PjtsPHQ8O2w8aTwwPjs+O2w8dDw7bDxpPDE+O2k8Mz47aTw0Pjs+O2w8dDx0PDs7bDxpPDE+Oz4+Ozs+O3Q8cDxwPGw8VGV4dDtWaXNpYmxlOz47bDxMYWJlbDtvPGY+Oz4+Oz47Oz47dDxwPHA8bDxWQUxVRTs+O2w8MjAwNi0xMi0yNjs+Pjs+Ozs+Oz4+Oz4+O3Q8O2w8aTwwPjs+O2w8dDw7bDxpPDA+Oz47bDx0PHA8cDxsPFRleHQ7PjtsPOe7n+iuoeaXpeacn++8mjIwMDYtMTItMjY7Pj47Pjs7Pjs+Pjs+Pjs+Pjs+Pjs+PjtsPEltYWdlQnV0dG9uMjtJbWFnZUJ1dHRvbjE7Pj5GZcgTFPeXeFj6SZvvRgjTTE5FHQ==" /><script language="javascript" type="text/javascript">
    <!--
    function __doPostBack(eventTarget, eventArgument) {
    var theform;
    if (window.navigator.appName.toLowerCase().indexOf("microsoft") > -1) {
    theform = document.Form1;
    }
    else {
    theform = document.forms["Form1"];
    }
    theform.__EVENTTARGET.value = eventTarget.split("$").join(":");
    theform.__EVENTARGUMENT.value = eventArgument;
    theform.submit();
    }
    // -->
    </script>
    <link rel="stylesheet" type="text/css" href="../CalendarResource/Calendar.css">
    &nbsp;
    <table cellSpacing="0" cellPadding="0" width="600" align="center">
    <TBODY>
    <tr>
    <td align="center">
    <table id="tb" bordercolor="#559347" cellspacing="0" cellpadding="1" width="96%" align="center" border="1">
    <tr>
    <td height="40" colspan="4"><FONT face="宋体"></FONT></td>
    </tr>
    <tr>
    <td align="center" colspan="4">
    <P><FONT size="6"><STRONG>销 售 量 统 计</STRONG></FONT></P>
    </td>
    </tr>
    <tr>
    <td style="HEIGHT: 23px" height="23" colspan="4"><FONT face="宋体"><FONT face="宋体"><table id="RadioButtonList1" border="0" style="width:80px;">
    <tr>
    <td><input id="RadioButtonList1_0" type="radio" name="RadioButtonList1" value="年比较" onclick="__doPostBack('RadioButtonList1_0','')" language="javascript" /><label for="RadioButtonList1_0">年比较</label></td>
    </tr><tr>
    <td><input id="RadioButtonList1_1" type="radio" name="RadioButtonList1" value="月比较" checked="checked" onclick="__doPostBack('RadioButtonList1_1','')" language="javascript" /><label for="RadioButtonList1_1">月比较</label></td>
    </tr><tr>
    <td><input id="RadioButtonList1_2" type="radio" name="RadioButtonList1" value="日比较" onclick="__doPostBack('RadioButtonList1_2','')" language="javascript" /><label for="RadioButtonList1_2">日比较</label></td>
    </tr>
    </table><span id="Label2">相对日期</span><span class=DPFrame id="cEndDateTimePicker" style=";">
    <input id="cEnd_year" name="cEnd_year" class=DPYear type=text value="2006" size=4 maxlength=4 onfocus="return dp_focus('year');"  onkeypress="return KeyFilter('number');" onkeydown="return dp_keyDown('year');" onchange="dp_change();" onblur="dp_blur();">
    <span class='DPSpan'>-</span><input id="cEnd_month" name="cEnd_month" class=DPMonth type=text value="12" size=2 maxlength=2 onfocus="return dp_focus('month');"  onkeypress="return KeyFilter('number');" onkeydown="return dp_keyDown('month');" onchange="dp_change();" onblur="dp_blur();">
    <span class='DPSpan'>-</span><input id="cEnd_day" name="cEnd_day" class=DPDay type=text value="26" size=2 maxlength=2 onfocus="return dp_focus('day');"  onkeypress="return KeyFilter('number');" onkeydown="return dp_keyDown('day');" onchange="dp_change();" onblur="dp_blur();">
    <span class=DPSep></span>
    <img class="DPimg" src="../CalendarResource/Calendar.gif" onclick="GetCalendar(this,'cEnd'); return false;" title="点击选择日期">
    <input type=hidden value='2006-12-26' id="cEnd" name="cEnd">
    </span>
    &nbsp;
    <input type="image" name="ImageButton2" id="ImageButton2" src="../images/an-19.gif" alt="" border="0" /></FONT></FONT></td>
    </tr>
    <tr>
    <TD align="right" colspan="4"><span id="Label1">统计日期：2006-12-26</span></TD>
    </tr>
    <tr bgcolor="#C7F6B2" align="center">
    <td>机构名称</td>
    <td>12月</td>
    <td>上月订单数</td>
    <td>与上月对比</td>
    </tr>
    <tr bgcolor="#E9FCD9">
    <td>海淀</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>魏公村</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>中关村</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr bgcolor="#E9FCD9">
    <td>西城</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>西直门</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>德胜门</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>三义庙</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr bgcolor="#E9FCD9">
    <td>朝阳</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>朝阳门</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>潘家园</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>西坝河</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr bgcolor="#E9FCD9">
    <td>昌平</td>
    <td>1000&nbsp</td>
    <td>89&nbsp</td>
    <td>911&nbsp</td>
    </tr>
    <tr>
    <td>回龙观</td>
    <td>1000&nbsp</td>
    <td>25&nbsp</td>
    <td>975&nbsp</td>
    </tr>
    <tr>
    <td>立水桥</td>
    <td>0&nbsp</td>
    <td>64&nbsp</td>
    <td>-64&nbsp</td>
    </tr>
    <tr bgcolor="#E9FCD9">
    <td>房山</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>豆店</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr bgcolor="#E9FCD9">
    <td>顺义</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>空港</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr bgcolor="#E9FCD9">
    <td>怀柔</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr>
    <td>怀柔镇政府</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    <td>0&nbsp</td>
    </tr>
    <tr bgcolor="Color [MediumAquamarine]">
    <td>合计：</td>
    <td>1000&nbsp</td>
    <td>89&nbsp</td>
    <td>911&nbsp</td>
    </tr>
    </table> </td>
    </tr>
    <tr>
    <td height="10"><FONT face="宋体"></FONT></td>
    </tr>
    <tr>
    <td align="center"><input type="image" name="ImageButton1" id="ImageButton1" src="../images/an-15.gif" alt="" border="0" /></FONT></td>
    </tr>
    <script language="javascript">var _DatePickerCssPath='../CalendarResource/Calendar.css';
    var _DatePickerImagePath='../CalendarResource/';</script>
    <script language="javascript" src="../CalendarResource/Calendar.js"></script><IFRAME id=iFrmCalendar name=iFrmCalendar style='display:none'></IFRAME></form>
    </TBODY></TABLE>
    </body>
    </HTML>
    慕白兄帮我分析一下
      

  6.   

    自己解决了，原因不在于导出的代码，而是在点击导出按钮时，事件重新发回服务器端，而在该事件里没有重新邦定table所以table里的内容无法显示！在这还是谢谢慕白兄！