开发者

How to Un-Hide a hidden row in Excel using Apache Poi in Java?

I have:

开发者_运维技巧import org.apache.poi.ss.usermodel.Row;

if ((currentRow = sheet.getRow(currentDataRow)) == null) {
            currentRow = sheet.createRow(currentDataRow);   // Creates a new row.
        }

// How to un-hide currentRow ?

currentRow is hidden, so to un-hide this row using this currentRow object?

Please help.. !!


Looks like it's getRowStyle().setHidden():

currentRow.getRowStyle().setHidden(false);

More info on getRowStyle.


I had poi-3.7 and these methods didn't show up either.

Downloaded the latest one poi-3.8-beta4 and row.setRowStye() and row.getRowStye() are present


Row.getRowStyle(): Returns the whole-row cell styles. Most rows won't have one of these, so will return null.

But you can check if this row is hidden by row.getZeroHeight() and show row using row.setZeroHeight(false);

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜