<p>这两天在做动态生成excel,学了下POI,还是蛮简单的.但是做项目的时候遇到了一个问题,就是合并单元格后,同一行 后面的列 会覆盖 前面的列的值</p>
<p>还傻傻的发了个帖子http://bbs.csdn.net/topics/390819393</p>
<p><span style="color:rgb(51,51,51); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:24px; background-color:rgb(245,245,245)">目标:简单的实现合并单元格并且填充值的功能</span><br style="color:rgb(51,51,51); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:24px; background-color:rgb(245,245,245)"> <span style="color:rgb(51,51,51); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:24px; background-color:rgb(245,245,245)">问题:后面填充的同一行的合并单元格值 会 将 同一行的前一个覆盖,求解惑</span><br style="color:rgb(51,51,51); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:24px; background-color:rgb(245,245,245)"> <span style="color:rgb(51,51,51); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:24px; background-color:rgb(245,245,245)">下面粘出代码</span><br style="color:rgb(51,51,51); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:24px; background-color:rgb(245,245,245)"> </p>
<div style="list-style:none; margin:0px; padding:0px; border:none; outline:none 0px; color:rgb(51,51,51); font-family:Helvetica,Tahoma,Arial,sans-serif; font-size:14px; line-height:24px; background-color:rgb(245,245,245)">
<div class="syntaxhighlighter java" id="highlighter_431531" style="width:758px; margin:0px; position:relative!important; overflow:auto; font-size:1em!important; background-color:white!important; list-style:none; padding:0px; border:none; outline:none 0px">
<div class="toolbar" style="list-style:none; width:757.234375px; margin:0px!important; padding:0px!important; border:none!important; outline:0px!important; background-color:rgb(245,245,245)!important; bottom:auto!important; float:none!important; height:24px!important; left:auto!important; overflow:visible!important; position:static!important; right:0px!important; top:0px!important; vertical-align:baseline!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-weight:bold!important; font-size:10px!important; min-height:inherit!important; z-index:10!important; text-indent:6px!important">
<span style="height:24px!important">Java code</span>
<span class="clipboardCopyBtn" style="height:16px!important; line-height:16px!important; margin-left:12px; display:inline-block; vertical-align:middle; width:16px!important" title="复制"></span>
<div class="d_clip_button" style="list-style:none; margin:0px!important; padding:0px!important; border:0px!important; outline:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; overflow:visible!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-weight:normal!important; font-size:1em!important; min-height:inherit!important">
</div>
<span class="clipboardWindowBtn" style="height:16px!important; line-height:16px!important; margin-left:12px; display:inline-block; vertical-align:middle; width:16px!important; text-indent:-5000px!important"><a href="http://bbs.csdn.net/topics/390819393#clipboardWindow" rel="noopener noreferrer" style="color:white!important; text-decoration:none!important; border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:1px 0px 0px!important; position:static!important; right:auto!important; text-align:center!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-weight:normal!important; font-size:1em!important; min-height:inherit!important; display:block!important" target="_blank" title="源码">?</a></span>
</div>
<table border="0" cellpadding="0" cellspacing="0" style="border-spacing:0px; max-width:100%; border:1px solid rgb(169,203,238); margin:0px 0px 8px; width:753px; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; outline:0px!important; overflow:visible!important; padding:5px 0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; font-family:Consolas,'Bitstream Vera Sans Mono','Courier New',Courier,monospace!important; font-size:1em!important; min-height:inherit!important"><tbody style="border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:baseline!important; width:auto!important; font-size:1em!important; min-height:inherit!important"><tr style="border:0px!important; bottom:auto!important; float:none!important; height:auto!important; left:auto!important; line-height:1.1em!important; margin:0px!important; outline:0px!important; overflow:visible!important; padding:0px!important; position:static!important; right:auto!important; top:auto!important; vertical-align:b |
|
转播
