nk,
The excel files I am using are .xls and .xlsx, so XML is not always
available. Since the API exposes isColumnHidden() in the Sheet
interface, I would expect the same functionality exist for rows
without the need to get the XML.
Paul Spencer
Paul Spencer
On Oct 26, 2009, at 10:02 AM, Kalpana wrote:
Paul Spencer <paulspencer <at> mindspring.com> writes:
I am using poi 3.5-FINAL with both .xls and .xlsx files.
How do I determine if a rows is hidden?
o There is no sheet.isRowHidden(rowNumber)
o cell.getCellStyle().getHidden() return false when the cell is on
a rows that is hidden.
Paul Spencer
Hi Paul,
you would want to retrieve the XML node of the node, and check for
the hidden
attribute set to 1.
If you need more info, write to me.
Regards,
nk
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
