Class: Spreadsheet::Excel::Error

Inherits:
Object
  • Object
show all
Defined in:
lib/spreadsheet/excel/error.rb

Overview

This class encapsulates Excel Error-Codes

Constant Summary collapse

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
}

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(code) ⇒ Error

Argument or function not available



16
17
18
 
# File 'lib/spreadsheet/excel/error.rb', line 16

def initialize code
  @code = code
end

Instance Attribute Details

#code ⇒ Object (readonly)

Returns the value of attribute code.



6
7
8
 
# File 'lib/spreadsheet/excel/error.rb', line 6

def code
  @code
end

Instance Method Details

#value ⇒ Object

The String value Excel associates with an Error code



22
23
24
 
# File 'lib/spreadsheet/excel/error.rb', line 22

def value
  ERROR_VALUES.fetch @code, "#UNKNOWN"
end