怎么把HTML中的TABLE放入EXCEL中，再可以保存EXCEL文档

RT

解决方案 »

  1.   

    声明Response.ContentType="ms-excel" 写的有点错,具体的google之
      

  2.   

    1、 把Table控件声明为服务器控件
    /// <summary>
    /// 导出Excel
    /// </summary>
    /// <param name="page"></param>
    /// <param name="control"></param>
    public static void Export(Page page, Control control)
    {
    page.Response.Clear();
    page.Response.Buffer= true;
    page.Response.AppendHeader("Content-Disposition","Attachment;fileName=Export.xls");
    page.Response.ContentType = "application/vnd.ms-excel";
    page.Response.Charset = "";
    page.Response.ContentEncoding = Encoding.Default;  
    page.EnableViewState = false; StringWriter stringWriter = new StringWriter();
    HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
    control.RenderControl(htmlTextWriter); page.Response.Write(stringWriter.ToString());
    page.Response.End();
    }
      

  3.   

    网上copy的
    <HTML>
    <HEAD>
    <TITLE> New Document </TITLE></HEAD><BODY><table  id="table1" width="500"  border="1" cellpadding="0" cellspacing="0" bordercolor="#0099FF">
      <tr align="center">
        <td rowspan="2">标题1</td>
        <td colspan="2">标题2</td>
        <td rowspan="2">标题3</td>
        <td rowspan="2">标题4</td>
      </tr>
      <tr align="center">
        <td>子标题1</td>
        <td>子标题2</td>
      </tr>
      <tr align="center">
        <td>4545</td>
        <td>12</td>
        <td>12</td>
        <td>12</td>
        <td rowspan="4">1212</td>
      </tr>
      <tr align="center">
        <td>12</td>
        <td>12</td>
        <td>12</td>
        <td>12</td>
      </tr>
      <tr align="center">
        <td>12</td>
        <td>12</td>
        <td>21</td>
        <td>12</td>
      </tr>
      <tr align="center">
        <td>12</td>
        <td>12</td>
        <td>12</td>
        <td>12</td>
      </tr>
      <tr align="center">
        <td>12</td>
        <td>12</td>
        <td>12</td>
        <td>12</td>
        <td>121</td>
      </tr>
    </table>
    <input type="button" name="aa" onClick="preview()"><script language=javascript>
    function preview() { 
    window.clipboardData.setData("Text",document.all('table1').outerHTML);
    try
    {
    var ExApp = new ActiveXObject("Excel.Application")
    var ExWBk = ExApp.workbooks.add()
    var ExWSh = ExWBk.worksheets(1)
    ExApp.DisplayAlerts = false
    ExApp.visible = true
    }  
    catch(e)
    {
    alert("您的电脑没有安装Microsoft Excel软件！")
    return false
    } 
     ExWBk.worksheets(1).Paste;
     }
    </script></BODY>
    </HTML>
      

  4.   

    HttpContext.Current.Response.ContentType = "application/ms-excel";