怎么制作表头有合并单元格的工资条

掌心化雪1 · 发表于 2009-9-17 13:41

<table cellspacing="0" cellpadding="0" width="793" border="0" xstr="" style="WIDTH: 595pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="31" style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 992;"></col><col width="35" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1120;"></col><col width="52" style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 1664;"></col><col width="64" style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2048;"></col><col width="72" style="WIDTH: 54pt;"></col><col width="63" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2016;"></col><col width="57" style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 1824;"></col><col span="2" width="62" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1984;"></col><col width="48" style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1536;"></col><col width="40" style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1280;"></col><col width="43" style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1376;"></col><col width="52" style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 1664;"></col><col width="51" style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1632;"></col><col width="61" style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl23" width="31" height="38" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 23pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 28.5pt; BACKGROUND-COLOR: transparent;">序号</td><td class="xl24" width="35" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 26pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">部门</td><td class="xl22" width="52" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 39pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">姓名</td><td class="xl22" width="64" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">薪资标准</td><td class="xl22" width="72" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">基本工资</td><td class="xl22" width="63" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 47pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">电话补贴</td><td class="xl22" width="57" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 43pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">交通补贴</td><td class="xl26" width="124" colspan="2" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 94pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"> 绩效工资</td><td class="xl22" width="48" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 36pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">提成</td><td class="xl22" width="186" colspan="4" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 139pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">   扣工资</td><td class="xl22" width="61" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 46pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">应发工资合计</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" width="62" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 47pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">固定绩效</td><td class="xl22" width="62" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 47pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">考核绩效</td><td class="xl22" width="40" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 30pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">违纪</td><td class="xl22" width="43" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 32pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">迟到</td><td class="xl22" width="52" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 39pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">病假</td><td class="xl22" width="51" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 38pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">事假</td></tr></tbody></table>

四叶草VS幸福 · 发表于 2009-9-17 14:24

两列合并为一列就可以呀。需要合并的就合并不需要合并的就不合并[em04][em04][em04]

四叶草VS幸福 · 发表于 2009-9-17 14:25

说错拉，应该是两行合并为一行[em04][em06]

福建随风飘扬 · 发表于 2009-9-17 14:48

全部选中在合并咯

掌心化雪1 · 发表于 2009-9-17 14:54

合并为一行了，但是做工资条表头时，用公式只显示了第一行的数据，比如绩效工资下面有固定绩效和考核绩效两个栏目，我只显示绩效工资一栏，下面的两栏不显示，扣工资下面的四栏也不显示

上弦月 · 发表于 2009-10-13 21:44

我来看看呀

cxdlsqq · 发表于 2009-11-29 15:48

用word的邮件合并吧估计还要简单点何必伤脑筋不要一棵树上吊死

a3305692 · 发表于 2009-12-15 22:37

看看是怎么做的？

chuandong · 发表于 2010-1-5 15:06

不知道我也想知道啊有人知道吗？

		自动登录	找回密码
密码			注册