Have a look at the isSheetHidden(index) and isSheetVeryHidden(index) methods in 
the HSSFWorkbook class. All you do is call one of these methods on the workbook 
and pass the sheet index to it. Mustr admit that I do not know the difference 
between hidden and very hidden though.

--- On Mon, 10/13/08, Hardie82 <[EMAIL PROTECTED]> wrote:
From: Hardie82 <[EMAIL PROTECTED]>
Subject: Re: Hiding a sheet in Excel workbook using POI HSSF
To: [email protected]
Date: Monday, October 13, 2008, 11:20 PM

Hi. I want to identify hidden sheets in my workbook but i didn't find a
method. Can somebody help me?

Hardie


Michael Dolgonos wrote:
> 
> Can somebody please advise how to hide an Excel sheet using POI API so
> when
> the workbook is opened in MS Excel the sheet will be hidden.
> Thank you in advance,
> Michael D.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 
> 

-- 
View this message in context:
http://www.nabble.com/Hiding-a-sheet-in-Excel-workbook-using-POI-HSSF-tp1306699p19967667.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




      

Reply via email to