Skip to content
/ roo Public
forked from simonoff/roo

Roo provides an interface to Open Office, Excel, and Google Spreadsheets.

License

Notifications You must be signed in to change notification settings

kaktusyaka/roo

This branch is 1 commit ahead of, 3 commits behind simonoff/roo:master.

Folders and files

NameName
Last commit message
Last commit date
Jan 30, 2009
Mar 25, 2013
Jan 30, 2009
Jan 16, 2010
Jan 30, 2009
Feb 21, 2009
Jan 30, 2009
Jan 30, 2009
Jan 30, 2009
Oct 27, 2012
Jul 18, 2009
Jan 16, 2010
Jan 30, 2009
Jan 20, 2010
Jan 30, 2009

Repository files navigation

I'm no longer maintaining this code. It's under active development here and new releases should be coming from that repository:

https://github.com/Empact/roo

README for Roo

Roo is available here and on Rubyforge. You can install the official release with 'gem install roo' or refer to the installation instructions below for the latest development gem.

Homepage: http://roo.rubyforge.org/

Gemcutter: http://rubygems.org/gems/roo

Installation

# Run the following if you haven't done so before:
gem sources -a http://gems.github.com/

# Install the gem:
sudo gem install roo

Usage:

require 'rubygems'
require 'roo'

s = Openoffice.new("myspreadsheet.ods")      # creates an Openoffice Spreadsheet instance
s = Excel.new("myspreadsheet.xls")           # creates an Excel Spreadsheet instance
s = Google.new("myspreadsheetkey_at_google") # creates an Google Spreadsheet instance
s = Excelx.new("myspreadsheet.xlsx")         # creates an Excel Spreadsheet instance for Excel .xlsx files

s.default_sheet = s.sheets.first  # first sheet in the spreadsheet file will be used

# s.sheet is an array which holds the names of the sheets within
# a spreadsheet.
# you can also write
# s.default_sheet = s.sheets[3] or
# s.default_sheet = 'Sheet 3'

s.cell(1,1)                                 # returns the content of the first row/first cell in the sheet
s.cell('A',1)                               # same cell
s.cell(1,'A')                               # same cell
s.cell(1,'A',s.sheets[0])                   # same cell

# almost all methods have an optional argument 'sheet'.
# If this parameter is omitted, the default_sheet will be used.

s.info                                      # prints infos about the spreadsheet file

s.first_row                                 # the number of the first row
s.last_row                                  # the number of the last row
s.first_column                              # the number of the first column
s.last_column                               # the number of the last column

# limited font information is available

s.font(1,1).bold?
s.font(1,1).italic?
s.font(1,1).underline?

see http://roo.rubyforge.org for a more complete tutorial

About

Roo provides an interface to Open Office, Excel, and Google Spreadsheets.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Ruby 90.2%
  • JavaScript 9.8%