Class Excel
In: lib/roo/excel.rb
Parent: GenericSpreadsheet

Class for handling Excel-Spreadsheets

Methods

cell   celltype   first_column   first_row   formula   formula?   formulas   last_column   last_row   new   sheets   to_s  

Constants

EXCEL_NO_FORMULAS = 'formulas are not supported for excel spreadsheets'

Public Class methods

Creates a new Excel spreadsheet object. Parameter packed: :zip - File is a zip-file

Public Instance methods

returns the content of a cell. The upper left corner is (1,1) or (‘A’,1)

returns the type of a cell:

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

returns the first non empty column

returns the first non empty row

returns NO formula in excel spreadsheets

raises an exception because formulas are not supported for excel files

returns NO formulas in excel spreadsheets

returns the last non empty column

returns the last non empty row

returns an array of sheet names in the spreadsheet

shows the internal representation of all cells mainly for debugging purposes

[Validate]