Win a copy of GANs in ActionE this week in the AI forum
or WebAssembly in Action in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Joe Ess
  • salvin francis
  • fred rosenberger

Apache POI - XSSFWorkbook - Disable Horizontal Scroll Bar

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.

Today you are you, that is turer than true. There is no one alive who is youer than you! - Seuss. Tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!