C#网页导出<tabel>任意tabel嵌套,多个tabel

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
< script  runat = "server" >
     protected void writeXls(object sender, EventArgs e)
     {
         Response.Clear();
         Response.Buffer = true;
         Response.ContentType = "application/vnd.ms-excel.numberformat:@";
         this.EnableViewState = false;
         Response.Charset = "UTF-8";
         Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");//设置输出流为简体中文  
         Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls");
         
         Response.Write(printHid.Value);
         Response.End();  
     }
</ script >
 
< html  xmlns = "http://www.w3.org/1999/xhtml" >
< head  runat = "server" >
     < title >无标题页</ title >
</ head >
< body >
     < form  id = "form1"  runat = "server" >
     < asp:HiddenField  ID = "printHid"  runat = "server"  />
     < div  id = "printDiv" >
     < table  cellpadding = 5  cellspacing = 1  bgcolor = "#cccccc"  border = 1  bordercolor = "#fffff" >
     < tbody >
      < tr  bgcolor = "#ffffff" >
       < td >1</ td >< td >2</ td >< td >3</ td >< td >4</ td >
      </ tr >
      < tr  bgcolor = "#ffffff" >
       < td  rowspan = 2 >合并列</ td >
       < td  colspan = 3 >合并行</ td >
      </ tr >
      < tr  bgcolor = "#ffffff" >
       < td  colspan = 3 >
          < table  width = "100%"  cellpadding = 5  cellspacing = 1  bgcolor = "#cccccc"  border = 1  bordercolor = "#fffff" >< tr  bgcolor = "#ffffff" >< td >111</ td >< td >222</ td >< td >333</ td ></ tr ></ table >      
       </ td >
      </ tr >
     </ tbody >
     </ table >
     </ div >
     < asp:Button  ID = "Button1"  runat = "server"  Text = "导出"  OnClientClick = "getHtmltoValue()"  OnClick = "writeXls"  />
     < script  type = "text/javascript" >
     function getHtmltoValue(){
     document.getElementById("<%=printHid.ClientID%>").value=document.getElementById("printDiv").innerHTML;
     }
     </ script >
     </ form >
</ body >
</ html >
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值