Hello everyone,
I'm very new to POI, and am trying to add in a feature to an application which
uses it for the loading/parsing of manually-created xls sheets. The portion
with which I'm working iterates through the rows in a sheet and adds them to an
ArrayList<RowData> for further processing. The loop works fine - I'm getting
the data from the rows. However, I am attempting to modify the program to skip
over hidden rows. It seems as if POI is not correctly setting the _hidden
property for my rows, nor for the cells within them. Using both 2.2-FINAL and
2.6, I have tried...
for (int i = firstRow + 1; i <= lastRow; i++){
HSSFRow row = sheet.getRow(i);
if(row.getRowStyle()!=null && !row.getRowStyle().getHidden()){
//WORK
}
}
and also...
for (int i = firstRow + 1; i <= lastRow; i++){
HSSFRow row = sheet.getRow(i);
if(row.getCell(1).getCellStyle()!=null &&
!row.getCell(1).getCellStyle().getHidden()){
//WORK
}
}
getHidden() seems to always return false, even if I hide all the rows in the
sheet. I presume the problem is me. Is there something which I should be
doing to initialize the style object, or am I misusing the method? I tried
looking into the source, and am still investigating how POI instantiates
sheets, but so far have come up dry. Any help would be greatly appreciated,
and any additional information which might be needed to diagnose the issue, I
would be happy to provide.
Jonathan Pittard
RadarFind, Inc
Morrisville, NC, USA
