module Asposecellsjava::ManagingWorksheets

Public Class Methods

new() click to toggle source
# File lib/asposecellsjava/managingworksheets.rb, line 3
def initialize()
    @data_dir = File.dirname(File.dirname(File.dirname(__FILE__))) + '/data/'

    # Adding Worksheets to a New Excel File
    add_worksheet(workbook)        

    # Adding Worksheets to a Designer Spreadsheet
    add_worksheet_to_designer_spreadsheet()

    # Accessing Worksheets using Sheet Name
    get_worksheet()

    # Removing Worksheets using Sheet Name
    remove_worksheet_by_name()

    # Removing Worksheets using Sheet Name
    remove_worksheet_by_index()
end

Public Instance Methods

add_worksheet() click to toggle source
# File lib/asposecellsjava/managingworksheets.rb, line 22
def add_worksheet()
    # Instantiating a Workbook object
    workbook = Rjb::import('com.aspose.cells.Workbook').new

    # Adding a new worksheet to the Workbook object
    worksheets = workbook.getWorksheets()

    sheet_index = worksheets.add()
    worksheet = worksheets.get(sheet_index)

    # Setting the name of the newly added worksheet
    worksheet.setName("My Worksheet")

    # Saving the modified Excel file in default (that is Excel 2003) format
    workbook.save(@data_dir + "book.out.xls")

    puts "Sheet added successfully."
end
add_worksheet_to_designer_spreadsheet() click to toggle source
# File lib/asposecellsjava/managingworksheets.rb, line 41
def add_worksheet_to_designer_spreadsheet()
    # Creating a file stream containing the Excel file to be opened
    fstream = IO.sysopen(@data_dir + 'book1.xls', "w")

    # Instantiating a Workbook object with the stream
    workbook = Rjb::import('com.aspose.cells.Workbook').new(fstream)

    # Adding a new worksheet to the Workbook object
    worksheets = workbook.getWorksheets()
    sheet_index = worksheets.add()
    worksheet = worksheets.get(sheet_index)

    # Setting the name of the newly added worksheet
    worksheet.setName("My Worksheet")

    # Saving the modified Excel file in default (that is Excel 2003) format
    workbook.save(@data_dir + "book1.out.xls")
end
get_worksheet() click to toggle source
# File lib/asposecellsjava/managingworksheets.rb, line 60
def get_worksheet()
    # Creating a file stream containing the Excel file to be opened
    fstream = IO.sysopen(@data_dir + 'book1.xls', "w")

    # Instantiating a Workbook object with the stream
    workbook = Rjb::import('com.aspose.cells.Workbook').new(fstream)

    # Accessing a worksheet using its sheet name
    worksheet = workbook.getWorksheets().get("Sheet1")

    puts worksheet.to_string
end
remove_worksheet_by_index() click to toggle source
# File lib/asposecellsjava/managingworksheets.rb, line 90
def remove_worksheet_by_index()
    # Creating a file stream containing the Excel file to be opened
    fstream = IO.sysopen(@data_dir + 'book1.xls', "w")

    # Instantiating a Workbook object with the stream
    workbook = Rjb::import('com.aspose.cells.Workbook').new(fstream)

    # Removing a worksheet using its sheet name
    workbook.getWorksheets().removeAt(0)
    
    # Saving the Excel file
    workbook.save(@data_dir + "book.out.xls")
    
    # Print Message
    puts "Sheet removed successfully."
end
remove_worksheet_by_name() click to toggle source
# File lib/asposecellsjava/managingworksheets.rb, line 73
def remove_worksheet_by_name()
    # Creating a file stream containing the Excel file to be opened
    fstream = IO.sysopen(@data_dir + 'book1.xls', "w")

    # Instantiating a Workbook object with the stream
    workbook = Rjb::import('com.aspose.cells.Workbook').new(fstream)

    # Removing a worksheet using its sheet name
    workbook.getWorksheets().removeAt("Sheet1")
    
    # Saving the Excel file
    workbook.save(@data_dir + "book.out.xls")
    
    # Print Message
    puts "Sheet removed successfully."
end