Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Apache POI - XSSFWorkbook - Disable Horizontal Scroll Bar  RSS feed

Joshua Barrett
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello one and all,

I have a fair bit of experience in building excel files in the .xls file format using HSSFWorkbook and the other asociated HSSF classes.
During my experiances I have been required to disable the horizontal scroll bar. I found a way of doing this using HSSFWorkbook with the following code.

However I now need to produce .xlsx files and I am struggling to find a way of disabling horizontal scroll bars.

Has anyone managed to find a way of manipulating window gui setting for excel for XSSFWorkbook?

As a side note, the reason I wish to remove horizontal scroll bar is due to there being many sheets and no need for the user to need the horizontal scroll bar, by removing the scroll bar there is more space to see more sheets at once.

Cheers guys.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!