JS打印表格（HTML定义格式）

最新推荐文章于 2023-04-06 15:11:59 发布
最新推荐文章于 2023-04-06 15:11:59 发布
阅读量298 收藏 1
点赞数
文章标签： javascript ruby json ViewUI

 <script type="text/javascript">
        function printEmpty() {
            var w = window.open("工作日志.htm");//
            w.focus();
            w.print();
        }

        //data:工作日志id
        function printData(data) {
            msg = data; //往表格中写入数据
            var w = window.open("工作日志(数据).htm");
            w.focus();
        }
    </script>

首先。用HTML定义好所有的数据格式（呈表格状）然后再用JQuery来进行网页数据的替换

怎么替换的那？就是非常简单。进行标注就OK了。把你要替换的数据用特殊的符号标注好。对应的名字再和你 传递过来的数据名称一致的话。那么就可以直接替换数据就OK了。    这里CSS布局的时候用到一些简单的EXCEL属性。就这么简单。

 

 缺点：

1. 替换的过程中有可能已经执行打印了。有可能打印出你初始定义并未替换的数据。所以建议替换打印换成ID填充。这样如果可以保证即使发生错误或者延时，用户看到的也是没有数据。而不是这些乱的数据。

2.JQUERY.AJAX的传递是有时间延迟的。如果能在 HTML模板上加个打印按钮，这样让用户可以先看一下数据。确定了再打印。

也可以直接在现在的代码中写一个CONFIRM来确认是否打印。不过还是建议使用第一种。

3.这样的HTML模板一定要统一放在FORM验证的文件夹下面。这样可以利用.NET的FORM验证机制来保证即使是HTML文件也验证是否有打印权限。

而且如果你登录了。那么就不会出错。如果你不登录就直接进行访问，那是无法访问的。

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="工作日志.files/filelist.xml">
<style id="环境调查_11939_Styles">
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
.font511939
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;}
.xl6311939
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:center;
	vertical-align:middle;
	border:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl6411939
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:center;
	vertical-align:middle;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl6511939
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:center;
	vertical-align:middle;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:none;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl6611939
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:center;
	vertical-align:middle;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl6711939
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:center;
	vertical-align:middle;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl6811939
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:22.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:center;
	vertical-align:middle;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
.xl6911939
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:11.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:center;
	vertical-align:middle;
	border-top:.5pt solid windowtext;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;}
-->
</style>

<script src="http://www.cnblogs.com/js/jquery/jquery.js" type="text/javascript"></script>
<script type="text/javascript">    
    writeData(window.opener.msg);

    function writeData(data) {
        var operationType = "PrintData";
        var utilUrl = "ExpelManageUtil.aspx";
        var pdata = "operationType=" + operationType + "&id=" + data;
        $.ajax({
            url: utilUrl, //后台处理类
            type: "POST",
            data: pdata,
            dataType: "json",
            timeout: 1000,
            error: function(data) { alert("出现错误或者您没有权限！"); },
            success: function(data) {
                var b = document.body.innerHTML;
                for (var elem in data) {//遍历data中的每一个属性及属性值
                    b = b.replace("$" + elem, data[elem]); 
                } 
                document.body.innerHTML = b;

                window.print(); //打印本页
            }
        });

    }
</script>

</head>

<body>
<!--[if !excel]>　　<![endif]-->
<!--下列信息由 Microsoft Office Excel 的“发布为网页”向导生成。-->
<!--如果同一条目从 Excel 中重新发布，则所有位于 DIV 标记之间的信息均将被替换。-->
<!----------------------------->
<!--“从 EXCEL 发布网页”向导开始-->
<!----------------------------->

<div id="环境调查_11939" align=center x:publishsource="Excel">

<table x:str border=0 cellpadding=0 cellspacing=0 width=871 class=xl6411939
 style='border-collapse:collapse;table-layout:fixed;width:655pt'>
 <col class=xl6411939 width=42 style='mso-width-source:userset;mso-width-alt:
 1344;width:32pt'>
 <col class=xl6411939 width=72 style='width:54pt'>
 <col class=xl6411939 width=42 style='mso-width-source:userset;mso-width-alt:
 1344;width:32pt'>
 <col class=xl6411939 width=60 style='mso-width-source:userset;mso-width-alt:
 1920;width:45pt'>
 <col class=xl6411939 width=64 style='mso-width-source:userset;mso-width-alt:
 2048;width:48pt'>
 <col class=xl6411939 width=72 style='width:54pt'>
 <col class=xl6411939 width=55 style='mso-width-source:userset;mso-width-alt:
 1760;width:41pt'>
 <col class=xl6411939 width=61 style='mso-width-source:userset;mso-width-alt:
 1952;width:46pt'>
 <col class=xl6411939 width=42 style='mso-width-source:userset;mso-width-alt:
 1344;width:32pt'>
 <col class=xl6411939 width=72 style='width:54pt'>
 <col class=xl6411939 width=38 style='mso-width-source:userset;mso-width-alt:
 1216;width:29pt'>
 <col class=xl6411939 width=72 style='width:54pt'>
 <col class=xl6411939 width=96 style='mso-width-source:userset;mso-width-alt:
 3072;width:72pt'>
 <col class=xl6411939 width=83 style='mso-width-source:userset;mso-width-alt:
 2656;width:62pt'>
 <tr height=45 style='mso-height-source:userset;height:33.75pt'>
  <td colspan=14 height=45 class=xl6811939 width=871 style='height:33.75pt;
  width:655pt'> 工 作 日 志</td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6311939 width=42 style='height:26.25pt;border-top:none;
  width:32pt'>日期</td>
  <td colspan=2 class=xl6611939 width=114 style='border-right:.5pt solid black;
  border-left:none;width:86pt'>$DoTime　</td>
  <td class=xl6311939 width=60 style='border-top:none;border-left:none;
  width:45pt'>星期</td>
  <td class=xl6311939 width=64 style='border-top:none;border-left:none;
  width:48pt'>$Week　</td>
  <td class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>天气</td>
  <td class=xl6311939 width=55 style='border-top:none;border-left:none;
  width:41pt'>$Weather　</td>
  <td class=xl6311939 width=61 style='border-top:none;border-left:none;
  width:46pt'>温度(℃)</td>
  <td class=xl6311939 width=42 style='border-top:none;border-left:none;
  width:32pt'>$Temp　</td>
  <td class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>风力风向</td>
  <td class=xl6311939 width=38 style='border-top:none;border-left:none;
  width:29pt'>$WindPower　</td>
  <td class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>$WindDirect　</td>
  <td class=xl6311939 width=96 style='border-top:none;border-left:none;
  width:72pt'>值班员</td>
  <td class=xl6311939 width=83 style='border-top:none;border-left:none;
  width:62pt'>$Watch　</td>
 </tr>
 <tr height=29 style='mso-height-source:userset;height:21.75pt'>
  <td  height=87 class=xl6311939 width=42 style='height:65.25pt;
  border-top:none;width:32pt'>参加人数(人)</td>
  <td  class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>$ActorNum1　</td>
  <td  class=xl6311939 width=42 style='border-top:none;width:32pt'>装备器材</td>
  <td colspan=3  class=xl6611939 width=196 style='border-right:.5pt solid black;
  border-left:none;width:147pt'>$Devices　</td>
  <td  class=xl6311939 width=55 style='border-top:none;width:41pt'>猎枪(支)</td>
  <td   class=xl6311939 width=61 style='border-top:none;border-left:none;
  width:46pt'>$GunNum　</td>
  <td  class=xl6311939 width=42 style='border-top:none;width:32pt'>进场时间</td>
  <td  class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>$BeginTime　</td>
  <td  class=xl6311939 width=38 style='border-top:none;width:29pt'>结束时间</td>
  <td   class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>$EndTime　</td>
  <td  class=xl6311939 width=96 style='border-top:none;width:72pt'>带队干部</td>
  <td  class=xl6311939 width=83 style='border-top:none;border-left:none;
  width:62pt'>$Leader1　</td>
 </tr>

 <tr height=52 style='mso-height-source:userset;height:39.0pt'>
  <td colspan=2 height=52 class=xl6311939 width=114 style='height:39.0pt;
  width:86pt'>消耗子弹(发)</td>
  <td colspan=2 class=xl6311939 width=102 style='border-left:none;width:77pt'>$MotorBullets　</td>
  <td colspan=3 class=xl6311939 width=191 style='border-left:none;width:143pt'>猎枪消耗子弹(发)</td>
  <td colspan=2 class=xl6311939 width=103 style='border-left:none;width:78pt'>$GunBullets　</td>
  <td colspan=2 class=xl6311939 width=110 style='border-left:none;width:83pt'>其他器材消耗</td>
  <td colspan=3 class=xl6311939 width=168 style='border-left:none;width:126pt'>$OtherDevices　</td>

 </tr>
 <tr height=31 style='mso-height-source:userset;height:23.25pt'>
  <td colspan=4 height=31 class=xl6311939 width=216 style='height:23.25pt;
  width:163pt'>环境检查情况及发现问题</td>
  <td colspan=3 class=xl6311939 width=191 style='border-left:none;width:143pt'>处理措施</td>
  <td colspan=2 class=xl6311939 width=103 style='border-left:none;width:78pt'>工作量</td>
  <td colspan=2 class=xl6311939 width=110 style='border-left:none;width:83pt'>器材消耗量</td>
  <td class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>工时(时)</td>
  <td class=xl6311939 width=96 style='border-top:none;border-left:none;
  width:72pt'>参加人数(人)</td>
  <td class=xl6311939 width=83 style='border-top:none;border-left:none;
  width:62pt'>带队干部</td>
 </tr>
 <tr height=65 style='mso-height-source:userset;height:48.75pt'>
  <td colspan=4 height=65 class=xl6311939 width=216 style='height:48.75pt;
  width:163pt'>$EnvironProblems　</td>
  <td colspan=3 class=xl6311939 width=191 style='border-left:none;width:143pt'>$Measure　</td>
  <td colspan=2 class=xl6311939 width=103 style='border-left:none;width:78pt'>$Works　</td>
  <td colspan=2 class=xl6311939 width=110 style='border-left:none;width:83pt'>$EquipExpend　</td>
  <td class=xl6311939 width=72 style='border-top:none;border-left:none;
  width:54pt'>$Hours　</td>
  <td class=xl6311939 width=96 style='border-top:none;border-left:none;
  width:72pt'>$ActorNum2　</td>
  <td class=xl6311939 width=83 style='border-top:none;border-left:none;
  width:62pt'>$Leader2　</td>
 </tr>
 <tr height=95 style='mso-height-source:userset;height:71.25pt'>
  <td colspan=2 height=95 class=xl6311939 width=114 style='height:71.25pt;
  width:86pt'>记<span style='mso-spacerun:yes'>    </span>事</td>
  <td colspan=12 class=xl6611939 width=757 style='border-right:.5pt solid black;
  border-left:none;width:569pt'>$Remember　</td>
 </tr>
 <tr height=95 style='mso-height-source:userset;height:71.25pt'>
  <td colspan=2 height=95 class=xl6311939 width=114 style='height:71.25pt;
  width:86pt'>待办事项</td>
  <td colspan=12 class=xl6611939 width=757 style='border-right:.5pt solid black;
  border-left:none;width:569pt'>$Plans　</td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td colspan=4 height=35 class=xl6511939 width=216 style='height:26.25pt;
  width:163pt'>填表人：$Writer</td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td colspan=4 class=xl6511939 width=230 style='width:173pt'>交班时间：$SwitchTime</td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td colspan=4 class=xl6511939 width=289 style='width:217pt'>接班人员：$Successor</td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=35 style='mso-height-source:userset;height:26.25pt'>
  <td height=35 class=xl6411939 width=42 style='height:26.25pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <tr height=30 style='mso-height-source:userset;height:22.5pt'>
  <td height=30 class=xl6411939 width=42 style='height:22.5pt;width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=60 style='width:45pt'></td>
  <td class=xl6411939 width=64 style='width:48pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=55 style='width:41pt'></td>
  <td class=xl6411939 width=61 style='width:46pt'></td>
  <td class=xl6411939 width=42 style='width:32pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=38 style='width:29pt'></td>
  <td class=xl6411939 width=72 style='width:54pt'></td>
  <td class=xl6411939 width=96 style='width:72pt'></td>
  <td class=xl6411939 width=83 style='width:62pt'></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=42 style='width:32pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=42 style='width:32pt'></td>
  <td width=60 style='width:45pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=55 style='width:41pt'></td>
  <td width=61 style='width:46pt'></td>
  <td width=42 style='width:32pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=38 style='width:29pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=96 style='width:72pt'></td>
  <td width=83 style='width:62pt'></td>
 </tr>
 <![endif]>
</table>

</div>


<!----------------------------->
<!--“从 EXCEL 发布网页”向导结束-->
<!----------------------------->
</body>

</html>

 

 

weixin_34360651
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
js打印表格
07-04
document.write('')
使用javascript打印和预览表格
kmyhy的专栏
06-02 7311
var hkey_root,hkey_path,hkey_keyhkey_root="HKEY_CURRENT_USER"hkey_path="//Software//Microsoft//Internet Explorer//PageSetup//"//设置网页打印的页眉页脚为空function pagesetup_null(){try{var RegWsh = new ActiveXObjec
js简单打印表格
weixin_30378311的博客
04-10 92
显示效果 打印效果（在chrome能显示打印效果） 方法 <table width="600px" border="1" align="center" cellspacing="0" cellpadding="0" bordercolor="#66CC99"></table> window.print(); 关键是设置borderc...
print-js 实现打印表格
weixin_61769998的博客
03-04 388
print-js 实现打印表格
在js中动态打印表格
点子二木
06-09 554
下面这个html可以在js中动态操作表格     &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtm...
韩顺平PHP JS JQUERY 所有视频下载种子 货真价实
01-26
9-30 2 javascript的闭包 js变量作用域 9-30 3 仿超级玛丽兄弟游戏制作 9-30 4 构造方法 对象的常用操作 9-30 5 面向对象的封装 继承 多态 9-30 6 面向对象的封装 继承 多态2 9-5 1.php xml编程①-xml基本介绍 xml...
xheditor-1.1.14
08-07
参数：可定义多个JSON对象数组，示例如下：{qq:{name:'QQ',count:55,width:25,height:25,line:11},msn:{name:'MSN',count:40,width:22,height:22,line:8}} name：表情分组名 count：表情数量 list：表情列表，例...
400个DreamWeaver插件
03-28
mxp/在Dreamweaver的File菜单下加一个Print code命令，用来打印代码 mxp/Splash Window，也叫chromeless splash , 一种效果很不错的浏览器窗口 mxp/在代码编辑窗的点右键，可以快速跳转到特定的代码行 mxp/在site...
（全）传智播客PHP就业班视频完整课程
10-30
9-30 2 javascript的闭包 js变量作用域 9-30 3 仿超级玛丽兄弟游戏制作 9-30 4 构造方法 对象的常用操作 9-30 5 面向对象的封装 继承 多态 9-30 6 面向对象的封装 继承 多态2 9-5 1.php xml编程①-xml基本介绍 xml...
js实现简单的打印表格
01-21
本文实例为大家分享了js实现打印表格的具体代码，供大家参考，具体内容如下 效果如下： 代码如下： <!DOCTYPE html> <html lang=en> <head> <meta charset=UTF-8> <title>打印表格</title> </head> <body> [removed] var data=[ {id:1001,icon:img/1.png,name:餐饮0,num:1,price:10}, {id:1002,icon:img/2.png,name:餐饮1,num:1,price:20},
JS打印报表控件
04-07
不错的js表报打印控件,试用简单.好用,找了好久,只有上传到空间才能用. 找了很久.基本打印功能都能实现,分页打印.打印预览. google浏览器测试效果不错.
js基本打印表格
Mabius的博客
01-13 1555
样式设置整个tsnle在也免得中间 css： <style> table{ /* 让整个table居中，显示在页面正中间 */ margin: auto; } </style> script： <script type="text/javascript"> //用弹框内容自己控制表格的长宽和边框 var w = prompt("请输入表格的宽度").
Js实现简单的打印表格
进击的葱
12-13 7299
效果如下： 代码如下： &lt;!DOCTYPE html&gt; &lt;html lang="en"&gt; &lt;head&gt; &lt;meta charset="UTF-8"&gt; &lt;title&gt;打印表格&lt;/title&gt; &lt;/head&gt; &lt;body&gt;
【转】js打印表格打印预览
VaJoy童鞋的专栏
12-05 1275
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> http://www.w3.org/1999/xhtml">                 var hkey_root, hkey_path, hkey_key         hkey_root = "HKEY_CURRENT_USER"         hk
前端js实现打印（导出）excel表格
hahahhahahahha123456的博客
06-26 692
<div class="tools"> <button type="button" class="btn green" id="excell" onclick="method5('dataTable')">导出考勤表</button> </div> js代码： //打印表格 var idTmr; function getExplore...
js实现分页打印表格和打印图片print-js
qq_33440740的博客
04-06 638
【代码】js实现分页打印表格和打印图片print-js。
html js创建表格
最新发布
06-11
可以使用HTML和JavaScript来创建表格，以下是一个简单的示例代码： ```html <!DOCTYPE html> <html> 创建表格 ()">创建表格 function createTable() { // 获取表格容器 var tableContainer = ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值