jruby -S gem install jruby_excelcom

require 'jruby_excelcom'

 
# if connected with block, COM will be uninitialized automatically
ExcelConnection::connect{ |con|
  wb = con.workbook "path/to/wb.xlsx"
  ws = wb.worksheet 'sheet1'
  
  puts ws.content #=> content in used range
  puts ws.content('A1:B3') #=> content in range A1 to B3
  
  # set content using an assignment with a hash, or by calling set_content
  ws.content = { :range => 'A2:B3', :content => [[1,2],['abc','äöü']] }
  ws.set_content('A4:A6', [2,3,5])
  
  # get some color in there
  ws.set_fill_color('A1', ExcelColor::RED)
  ws.set_font_color('A1', ExcelColor::YELLOW)
  ws.set_border_color('A1', ExcelColor::PINK)
  
  ws_new = wb.add_worksheet 'newsheet' # create a new sheet ...
  ws_new.delete # ... and delete it again
}
 
# connect to an existing instance without block, quit must be called, 
# otherwise COM will be left uninitialized!
con = ExcelConnection::connect(true)
# ...
con.quit