RubiOD - work with OpenDocument in pure Ruby¶ ↑

The rubiod gem is intended to provide cute ruby-style interface to work with OASIS Open Document Format files. For now it supports some functionality to read/modify OD spreadsheets (.ods).

Requirements¶ ↑

rubiod works with ruby 1.8.7 or higher. It is dependent on libxml-ruby and rubyzip gems

Download and installation¶ ↑

At least two ways available:

1. Build gem from source:

   git clone git://github.com/netoctone/rubiod.git; cd rubiod
   gem build rubiod.gemspec
   gem install rubiod-version.gem

2. Or add following line to Gemfile (if it’s in use):

   gem 'rubiod', :git => 'git://github.com/netoctone/rubiod.git'
   

ODS Showcase¶ ↑

Some examples of work with rubiod

Load rubiod itself¶ ↑

require 'rubygems'
require 'rubiod'

Load spreadsheet¶ ↑

Document initializer takes a path to file or any IO object

spread = Rubiod::Spreadsheet.new('path/to/file.ods')

File.open('path/to/file.ods', 'r') do |f|
  Rubiod::Spreadsheet.new(f)
end

Extract document parts¶ ↑

RubiOD allows to work separately with worksheets and rows of document:

worksheet = spread['Worksheet']
worksheet = spread[0]

row = spread[0, 10]

row = worksheet[10]

Read data¶ ↑

puts spread['Worksheet', 0, 0]
puts worksheet[0, 0]
puts row[0]

Modify data¶ ↑

Setting new value in a cell:

spread[0, 1, 5] = 'new data'
worksheet[1, 5] = 10
row[5] = object

Inserting new row after specified one, applying the same formatting:

worksheet.insert 10

Deleting an entire row (with shifting lower ones up):

worksheet.delete 11

Apply modifications¶ ↑

spread.save

License¶ ↑

RubiOD is released under the MIT license.