You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by mi...@jpmchase.com on 2005/11/02 15:39:00 UTC
Hiding a sheet in Excel workbook using POI HSSF
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Hiding a sheet in Excel workbook using POI HSSF
Posted by Hardie82 <th...@yahoo.de>.
Thanks a lot. I thought it is an attribute of sheet and not of workbook.
Hardie
Anthony Andrews wrote:
>
> 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.
>
--
View this message in context: http://www.nabble.com/Hiding-a-sheet-in-Excel-workbook-using-POI-HSSF-tp1306699p19968000.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Hiding a sheet in Excel workbook using POI HSSF
Posted by Anthony Andrews <py...@yahoo.com>.
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 <th...@yahoo.de> wrote:
From: Hardie82 <th...@yahoo.de>
Subject: Re: Hiding a sheet in Excel workbook using POI HSSF
To: user@poi.apache.org
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: poi-user-unsubscribe@jakarta.apache.org
> 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Hiding a sheet in Excel workbook using POI HSSF
Posted by Hardie82 <th...@yahoo.de>.
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: poi-user-unsubscribe@jakarta.apache.org
> 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org