Class Google
In: lib/roo/google.rb
Parent: GenericSpreadsheet

Methods

cell   celltype   column   date?   empty?   first_column   first_row   formula   formula?   formulas   last_column   last_row   new   row   set_value   sheets   time?   timestring_to_seconds  

Public Class methods

date?(string)

is String a date with format DD/MM/YYYY

time?(string)

is String a time with format HH:MM:SS?

Public Instance methods

cell(row, col, sheet=nil)

Returns the content of a spreadsheet-cell. (1,1) is the upper left corner. (1,1), (1,’A’), (‘A’,1), (‘a’,1) all refers to the cell at the first line and first row.

celltype(row, col, sheet=nil)

returns the type of a cell:

  • :float
  • :string,
  • :date
  • :percentage
  • :time
column(columnnumber, sheet=nil)

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

empty?(row, col, sheet=nil)

true, if the cell is empty

first_column(sheet=nil)

returns the first non-empty column in a sheet

first_row(sheet=nil)

returns the first non-empty row in a sheet

formula(row,col,sheet=nil)

Returns the formula at (row,col). Returns nil if there is no formula. The method formula? checks if there is a formula.

formulas(sheet=nil)

returns each formula in the selected sheet as an array of elements [row, col, formula]

last_column(sheet=nil)

returns the last non-empty column in a sheet

last_row(sheet=nil)

returns the last non-empty row in a sheet

row(rownumber,sheet=nil)

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

set_value(row,col,value,sheet=nil)

sets the cell to the content of ‘value’ a formula can be set in the form of ’=SUM(…)’

sheets()

returns an array of sheet names in the spreadsheet

[Validate]