xjh286865
发表于 2009-7-9 10:06:00
<p>我找到方法了，在excel中用lisp格式就可以了，如下：</p><p><table border="0" cellspacing="0" cellpadding="0" width="488" style="WIDTH: 366pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="488" style="WIDTH: 366pt; mso-width-source: userset; mso-width-alt: 15616;"></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td class="xl67" height="16" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #e46d0a; WIDTH: 366pt; HEIGHT: 12pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">setvar cecolor 1</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl68" height="16" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc000; WIDTH: 366pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "style" "FWZS2" "华文中宋" "0" "1" "0" "n" "n")</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl65" height="16" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "0,50" "10" "0" "IV46+750")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "0.000,2.483" "10" "0" "▽97.483")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "0.000,2.483" "10" "0" "▽97.483")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "-31.880,11.621" "10" "0" "▽106.621")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "31.880,11.621" "10" "0" "▽106.621")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "-48.880,17.621" "10" "0" "▽112.621")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "48.880,17.621" "10" "0" "▽112.621")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "-68.880,23.621" "10" "0" "▽118.621")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "68.880,23.621" "10" "0" "▽118.621")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "-79.200,27.781" "10" "0" "▽122.781")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "82.880,29.621" "10" "0" "▽124.621")</font></td></tr><tr height="32" style="HEIGHT: 24pt;"><td class="xl65" height="32" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 24pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "-101.800,35.881" "10" "0" "▽130.881")</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl65" height="16" width="488" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 366pt; HEIGHT: 12pt; BORDER-TOP: windowtext; BORDER-RIGHT: #ece9d8;"><font size="2" face="黑体">(command "text" "j" "bc" "103.820,36.061" "10" "0" "▽131.061")</font></td></tr></tbody></table></p>
xjh286865
发表于 2009-7-9 10:20:00
<p> “ <font color="#ff0000">" </font>”在excel中用char(34)实现</p>
fengyun31
发表于 2016-5-25 20:50:14
非常有用！