Display or Hide Scroll Bars in Ruby

Aspose.Cells - Display or Hide Scroll Bars

Hiding Scroll Bars

To hide Scroll Bars using Aspose.Cells Java for Ruby, call displayhidescrollbars module.

Ruby Code

 data_dir = File.dirname(File.dirname(File.dirname(__FILE__))) + '/data/'

\# Instantiating a Workbook object by excel file path

workbook = Rjb::import('com.aspose.cells.Workbook').new(data_dir + 'Book1.xls')

\# Hiding the vertical scroll bar of the Excel file

workbook.getSettings().setVScrollBarVisible(false)

\# Hiding the horizontal scroll bar of the Excel file

workbook.getSettings().setHScrollBarVisible(false)

\# Saving the modified Excel file in default (that is Excel 2003) format

workbook.save(data_dir + "output.xls")

puts "Scroll Bars are now hidden, please check the output file."

Making Scroll Bars Visible

Make scroll bars visible by setting the Workbook class' setVerticalScrollBarHidden() or setHorizontalScrollBarHidden() methods to true.

Ruby Code

 # Displaying the vertical scroll bar of the Excel file

workbook.getSettings().setVScrollBarVisible(true)

\# Displaying the horizontal scroll bar of the Excel file

workbook.getSettings().setHScrollBarVisible(true)

Download Running Code

Download Display or Hide Scroll Bars (Aspose.Cells) from any of the below mentioned social coding sites:

• GitHub