convert letters like ‘AB’ to a number

convert a number to something like this: ‘AB‘

set the working sheet in the document

true if cell is empty

find a row either by row number or a condition Caution: this works only within the default sheet -> set default_sheet before you call this method (experimental. see examples in the test_roo.rb file)

returns the number of the first non-empty column

first non-empty column as a letter

returns the number of the first non-empty row

Returns information of the spreadsheet document and all sheets within this document.

returns the number of the last non-empty column

last non-empty column as a letter

returns the number of the last non-empty row

converts cell coordinate to numeric values of row,col

reopens and read a spreadsheet document

recursively removes the current temporary directory this is only needed if you work with zipped files or files via the web

write the current spreadsheet to stdout or into a file

returns a rectangular area (default: all cells) as yaml-output you can add additional attributes with the prefix parameter like: oo.to_yaml({"file"=>"flightdata_2007-06-26", "sheet" => "1"})