roo 在ruby中处理和操作excel

Roo这个gem在处理excel中以及有很长时间，而且生命力很强，作者仍更新，比如支持ruby1.9

个人认为有必要在这个专辑了，给这个gem记录一笔，

安装

#1.8版
gem sources -a http://gems.github.com/

sudo gem install roo -v 1.3.11

使用如下：

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?

官网tutorial如下：
http://roo.rubyforge.org

话说，老猪很多时候确实只知道copy官网，别人说的对，俺还必须承认。抄一点也是学习，为啥不抄，骂一骂也是关注，为啥不骂，嘿嘿

评论

1 楼 kewin 2010-12-03  

Currently only read-access is implemented.
Google spreadsheets can be read and written.[color=red][/color]