Re: xlsx Hide Worksheet

[Adrian Dragulescu]

Hi Eleanor, 

In the future, please send emails to the group and not to me directly. 

Once you have a workbook

wb <- createWorkbook()

you can do

wb$setSheetHidden(0L, 1L) if you want to hide the first sheet (0-based indexing in Java) 

See the documentation here

http://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setSheetHidden(int, int)

Best regards, 

Adrian

On Tue, Aug 5, 2014 at 10:14 AM, Anderson, Eleanor <eand...@transitchicago.com> wrote:

Dear Mr. Dragulescu,

 

Thank you for your excellent R package xlsx!  I use it for many things and it always works well.  I have one question:

 

The documentation says: “The user has control to set colors, fonts, data formats, add borders, hide/unhide sheets, add/remove rows, add/remove sheets, etc." (Emphasis mine.)  But I have scoured the documentation, and posted a Stack Overflow question, and still cannot find the way to hide sheets.  Can you point me to it?

 

Thanks much!

Ellie

 

Eleanor Anderson

Analyst, Performance Management

Chicago Transit Authority

[Anderson, Eleanor]

Will do and thanks for the answer!

 

Eleanor Anderson

Analyst, Performance Management

Chicago Transit Authority