R: Hide worksheet with package xlsx
Solution 1:
So that others having the same problem can find the answer, here is how developer Adrian Dragulescu replied to my email:
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)
I can confirm this works, and many thanks to Mr. Dragulescu.