开发者

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

开发者 https://www.devze.com 2023-03-24 15:59 出处:网络
I have: 开发者_运维技巧import org.apache.poi.ss.usermodel.Row; if ((currentRow = sheet.getRow(currentDataRow)) == null) {

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

精彩评论

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