poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Spencer <pau...@me.com>
Subject Re: How to determine if a row is hidden?
Date Mon, 26 Oct 2009 16:05:13 GMT
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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message