This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Apache POI - XSSFWorkbook - Disable Horizontal Scroll Bar Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Apache POI - XSSFWorkbook - Disable Horizontal Scroll Bar" Watch "Apache POI - XSSFWorkbook - Disable Horizontal Scroll Bar" New topic
Author

Apache POI - XSSFWorkbook - Disable Horizontal Scroll Bar

Joshua Barrett
Greenhorn

Joined: Sep 08, 2010
Posts: 27
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.

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Apache POI - XSSFWorkbook - Disable Horizontal Scroll Bar
 
Similar Threads
awt.List and Scrollbar
Horizontal scroll bar for SPECIFIC columns
Apache POI - How to hide Scroll Bars?
Finding file type XLS or XLSX using POI APIs.
XSSFWorkbook uses much more memory than HSSFWorkbook?