Module: Asposecellsjava::PageSetup
- Defined in:
- lib/asposecellsjava/pagesetup.rb
Instance Method Summary collapse
Instance Method Details
#initialize ⇒ Object
3 4 5 6 7 8 9 |
# File 'lib/asposecellsjava/pagesetup.rb', line 3 def initialize() # Page Orientation page_orientation() # Scaling Factor scaling() end |
#page_orientation ⇒ Object
11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
# 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 ⇒ Object
33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
# 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 |