Split Panes in Ruby

Aspose.Cells - Split Panes

To split panes using Aspose.Cells for Java in Ruby, simply invoke the SplitPanes module.

Ruby Code

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

# Instantiating a Workbook object by an Excel file path
workbook = Rjb::import('com.aspose.cells.Workbook').new(data_dir + 'Book1.xls')

# Set the active cell
workbook.getWorksheets().get(0).setActiveCell("A20")

# Split the worksheet window
workbook.getWorksheets().get(0).split()

# Saving the modified Excel file in the default format (Excel 2003)
workbook.save(data_dir + "SplitPanes output.xls")

puts "Panes split successfully."

Download Running Code

Download Split Panes (Aspose.Cells) from any of the below‑mentioned social coding sites:

• GitHub