Class Spreadsheet::Excel::Error
In: lib/spreadsheet/excel/error.rb
Parent: Object
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

This class encapsulates Excel Error-Codes

Methods

new   value  

Constants

ERROR_VALUES = { 0x00 => '#NULL!', # Intersection of two cell ranges is empty 0x07 => '#DIV/0!', # Division by zero 0x0F => '#VALUE!', # Wrong type of operand 0x17 => '#REF!', # Illegal or deleted cell reference 0x1D => '#NAME?', # Wrong function or range name 0x24 => '#NUM!', # Value range overflow 0x2A => '#N/A!', # Argument or function not available }

Attributes

code  [R] 

Public Class methods

[Source]

    # File lib/spreadsheet/excel/error.rb, line 16
16:   def initialize code
17:     @code = code
18:   end

Public Instance methods

The String value Excel associates with an Error code

[Source]

    # File lib/spreadsheet/excel/error.rb, line 21
21:   def value
22:     ERROR_VALUES.fetch @code, '#UNKNOWN'
23:   end

[Validate]