Roo这个gem在处理excel中以及有很长时间,而且生命力很强,作者仍更新,比如支持ruby1.9
个人认为有必要在这个专辑了,给这个gem记录一笔,
[b]安装[/b]
使用如下:
官网tutorial如下:
[url]http://roo.rubyforge.org[/url]
话说,[url=http://hlee.iteye.com]老猪[/url]很多时候确实只知道copy官网,别人说的对,俺还必须承认。抄一点也是学习,为啥不抄,骂一骂也是关注,为啥不骂,嘿嘿
个人认为有必要在这个专辑了,给这个gem记录一笔,
[b]安装[/b]
#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如下:
[url]http://roo.rubyforge.org[/url]
话说,[url=http://hlee.iteye.com]老猪[/url]很多时候确实只知道copy官网,别人说的对,俺还必须承认。抄一点也是学习,为啥不抄,骂一骂也是关注,为啥不骂,嘿嘿