Class Spreadsheet::Excel::Row
In: lib/spreadsheet/excel/row.rb
Parent: Spreadsheet::Row
Column Format Row Font Enumerable Worksheet\n[lib/spreadsheet/excel.rb\nlib/spreadsheet/worksheet.rb] Link Workbook Workbook\n[lib/spreadsheet/excel.rb\nlib/spreadsheet/excel/workbook.rb] SstEntry String Row Array Worksheet ExcelCompatibleWorkbook Format Worksheet Workbook DelegateClassSpreadsheet::Format Writer Compatibility Formula Reader\n[lib/parseexcel/parseexcel.rb\nlib/spreadsheet/excel/reader.rb\nlib/spreadsheet/excel/reader/biff5.rb\nlib/spreadsheet/excel/reader/biff8.rb] Error lib/spreadsheet/excel.rb lib/spreadsheet/link.rb lib/spreadsheet/formula.rb lib/spreadsheet/workbook.rb lib/spreadsheet/font.rb lib/spreadsheet/column.rb lib/spreadsheet/format.rb lib/spreadsheet/writer.rb lib/spreadsheet/row.rb Encodings lib/spreadsheet/excel.rb lib/spreadsheet/excel/row.rb lib/spreadsheet/excel/reader/biff5.rb lib/spreadsheet/excel/worksheet.rb lib/spreadsheet/excel/sst_entry.rb lib/spreadsheet/excel/error.rb lib/spreadsheet/excel/workbook.rb lib/spreadsheet/excel/writer/format.rb lib/spreadsheet/excel/writer/workbook.rb lib/spreadsheet/excel/writer/worksheet.rb Biff8 Writer Biff5 Biff8 Internals Offset Excel Datatypes ParseExcel Compatibility Spreadsheet dot/m_34_0.png

Excel-specific Row methods

Methods

[]   date   datetime   each  

Constants

LEAP_ERROR = Date.new 1900, 2, 28   The Excel date calculation erroneously assumes that 1900 is a leap-year. All Dates after 28.2.1900 are off by one.

Public Instance methods

Access data in this Row like you would in an Array. If a cell is formatted as a Date or DateTime, the decoded Date or DateTime value is returned.

[Source]

    # File lib/spreadsheet/excel/row.rb, line 31
31:   def [] idx, len=nil
32:     if len
33:       idx = idx...(idx+len)
34:     end
35:     if idx.is_a? Range
36:       data = []
37:       idx.each do |i|
38:         data.push enriched_data(i, at(i))
39:       end
40:       data
41:     else
42:       enriched_data idx, at(idx)
43:     end
44:   end

Force convert the cell at idx to a Date

[Source]

    # File lib/spreadsheet/excel/row.rb, line 15
15:   def date idx
16:     _date at(idx)
17:   end

Force convert the cell at idx to a DateTime

[Source]

    # File lib/spreadsheet/excel/row.rb, line 20
20:   def datetime idx
21:     _datetime at(idx)
22:   end

[Source]

    # File lib/spreadsheet/excel/row.rb, line 23
23:   def each &block
24:     size.times do |idx|
25:       block.call self[idx]
26:     end
27:   end

[Validate]