Contents

module Asposecellsjava
  module HelloWorld
    def initialize()
        data_dir = File.dirname(File.dirname(File.dirname(__FILE__))) + '/data/'
        
        # Instantiating a Workbook object that represents a Microsoft Excel file.
        workbook = Rjb::import('com.aspose.cells.Workbook').new
        
        # Note when you create a new workbook, a default worksheet,
        # "Sheet1", is by default added to the workbook.
        # Accessing the first worksheet in the book ("Sheet1").
        sheet = workbook.getWorksheets().get(0)

        # Access cell "A1" in the sheet.
        cell = sheet.getCells().get("A1")

        # Input the "Hello World!" text into the "A1" cell
        cell.setValue("Hello World!")
        
        # Saving the modified Excel file in default (that is Excel 2003) format
        file_format_type = Rjb::import('com.aspose.cells.FileFormatType')
        workbook.save(data_dir + "HelloWorld.xls", file_format_type.EXCEL_97_TO_2003)

        puts "Document has been saved, please check the output file."
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
asposecellsjava-0.0.3	lib/asposecellsjava/helloworld.rb
asposecellsjava-0.0.2	lib/asposecellsjava/helloworld.rb