module Asposecellsjava::CopyWorksheets
Public Class Methods
new()
click to toggle source
# File lib/asposecellsjava/copyworksheets.rb, line 3 def initialize() @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') # Copy Worksheets within a Workbook copy_worksheet(workbook) # Move Worksheets within Workbook move_worksheet(workbook) end
Public Instance Methods
copy_worksheet(workbook)
click to toggle source
# File lib/asposecellsjava/copyworksheets.rb, line 16 def copy_worksheet(workbook) # Create a Worksheets object with reference to the sheets of the Workbook. sheets = workbook.getWorksheets() # Copy data to a new sheet from an existing sheet within the Workbook. sheets.addCopy("Sheet1") # Saving the modified Excel file in default (that is Excel 2003) format workbook.save(@data_dir + "Copy Worksheet.xls") puts "Copy worksheet, please check the output file." end
move_worksheet(workbook)
click to toggle source
# File lib/asposecellsjava/copyworksheets.rb, line 29 def move_worksheet(workbook) # Get the first worksheet in the book. sheet = workbook.getWorksheets().get(0) # Move the first sheet to the third position in the workbook. sheet.moveTo(2) # Saving the modified Excel file in default (that is Excel 2003) format workbook.save(@data_dir + "Move Worksheet.xls") puts "Move worksheet, please check the output file." end