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

Methods

Public Class methods

is String a date with format DD/MM/YYYY

is String a date+time with format DD/MM/YYYY HH:MM:SS

Creates a new Google spreadsheet object.

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

Public Instance methods

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.

returns the type of a cell:

  • :float
  • :string
  • :date
  • :percentage
  • :formula
  • :time
  • :datetime

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

true, if the cell is empty

returns the first non-empty column in a sheet

returns the first non-empty row in a sheet

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

true, if there is a formula

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

returns the last non-empty column in a sheet

returns the last non-empty row in a sheet

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

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

returns an array of sheet names in the spreadsheet

[Validate]