Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 3641|回复: 2

[问题] 工资条打印时怎样能隔行出现

[复制链接]
发表于 2010-1-13 10:32 | 显示全部楼层 |阅读模式
<p>工资表头有基本工资,上班天数,奖金,实发工资等等,</p><p><table border="0" cellspacing="0" cellpadding="0" width="690" style="WIDTH: 520pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col><col width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col><col width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col><col span="4" width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col><col width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col><col width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col></colgroup><tbody><tr height="53" style="HEIGHT: 39.95pt; mso-height-source: userset;"><td class="xl24" height="53" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 52pt; HEIGHT: 39.95pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">姓名</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">月基本工资</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">日均工资</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">上班天数</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">应得基本工资</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">考核奖金</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">满勤奖</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">其他补助</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">岗位补助</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">实发工资</font></td></tr><tr height="53" style="HEIGHT: 39.95pt; mso-height-source: userset;"><td class="xl24" height="53" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 52pt; HEIGHT: 39.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">黄晶</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">700</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">23.33</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">27.5</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">641.6</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">50</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体"> </font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">20</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体"> </font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">711.6</font></td></tr><tr height="53" style="HEIGHT: 39.95pt; mso-height-source: userset;"><td class="xl24" height="53" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 52pt; HEIGHT: 39.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">姓名</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">月基本工资</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">日均工资</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">上班天数</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">应得基本工资</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">考核奖金</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">满勤奖</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">其他补助</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">岗位补助</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">实发工资</font></td></tr><tr height="53" style="HEIGHT: 39.95pt; mso-height-source: userset;"><td class="xl24" height="53" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 52pt; HEIGHT: 39.95pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">何瑶</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">700</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">23.33</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">29</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">700</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">50</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">30</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">20</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">50</font></td><td class="xl24" width="69" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 52pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">850</font></td></tr></tbody></table></p><p>哪位高手可以先给个代码,谢谢</p>
excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
发表于 2010-1-13 10:39 | 显示全部楼层
回复

使用道具 举报

发表于 2010-1-13 11:26 | 显示全部楼层

rr3gLHtl.rar (6.32 KB, 下载次数: 6)
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-13 02:29 , Processed in 0.250482 second(s), 9 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表