module Asposecellsjava::PageSetup
Public Class Methods
new()
click to toggle source
# File lib/asposecellsjava/pagesetup.rb, line 3 def initialize() # Page Orientation page_orientation() # Scaling Factor scaling() end
Public Instance Methods
page_orientation()
click to toggle source
# File lib/asposecellsjava/pagesetup.rb, line 11 def page_orientation() 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 # Accessing the first worksheet in the Excel file worksheets = workbook.getWorksheets() sheet_index = worksheets.add() sheet = worksheets.get(sheet_index) # Setting the orientation to Portrait page_setup = sheet.getPageSetup() page_orientation_type = Rjb::import('com.aspose.cells.PageOrientationType') page_setup.setOrientation(page_orientation_type.PORTRAIT) # Saving the modified Excel file in default (that is Excel 2003) format workbook.save(data_dir + "Page Orientation.xls") puts "Set page orientation, please check the output file." end
scaling()
click to toggle source
# File lib/asposecellsjava/pagesetup.rb, line 33 def scaling() 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') # Accessing the first worksheet in the Excel file worksheets = workbook.getWorksheets() sheet_index = worksheets.add() sheet = worksheets.get(sheet_index) # Setting the scaling factor to 100 page_setup = sheet.getPageSetup() page_setup.setZoom(100) # Saving the modified Excel file in default (that is Excel 2003) format workbook.save(data_dir + "Scaling.xls") puts "Set scaling, please check the output file." end