Class GenericSpreadsheet
In: lib/roo/generic_spreadsheet.rb
Parent: Object

Base class for all other types of spreadsheets

Methods

Attributes

default_sheet  [R] 
header_line  [RW]  sets the line with attribute names (default: 1)

Public Class methods

Public Instance methods

returns all values in this column as an array column numbers are 1,2,3,… like in the spreadsheet

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

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

returns all values in this row as an array row numbers are 1,2,3,… like in the spreadsheet

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”})

Protected Instance methods

konvertiert einen Key in der Form “12,45” (=row,column) in ein Array mit numerischen Werten ([12,45]) Diese Methode ist eine temp. Loesung, um zu erforschen, ob der Zugriff mit numerischen Keys schneller ist.

[Validate]