Methods

Spreadsheet::Excel::Internals

Binary Formats and other configurations internal to Excel. This Module is likely to shrink as Support for older Versions of Excel grows and more Binary formats are moved away from here for disambiguation. If you need to work with constants defined in this module and are confused by names like SEDOC_ROLOC, try reading them backwards. (The reason for this weird naming convention is that according to my ri, Ruby 1.9 renames Hash#index to Hash#key without backward compatibility. Since I did not want to pepper my code with RUBY_VERSION-checks, I settled on this strategy to make the transition to Ruby 1.9 as simple as possible.

Constants

BINARY_FORMATS
BUILTIN_FORMATS

From BIFF5 on, the built-in number formats will be omitted. The built-in formats are dependent on the current regional settings of the operating system. The following table shows which number formats are used by default in a US-English environment. All indexes from 0 to 163 are reserved for built-in formats.

BUILTIN_STYLES
CODEPAGES
COLOR_CODES

color_codes according to support.softartisans.com/kbview_1205.aspx synonyms are in comments when reverse lookup

EIGHT_BYTE_DOUBLE
ESCAPEMENT_TYPES
FONT_ENCODINGS
FONT_FAMILIES
FONT_WEIGHTS
LEAP_ERROR
NGILA_H_FX
NGILA_V_FX
NOITCERID_TXET_FX
OPCODES
OPCODE_SIZE
ROW_HEIGHT
SEDOCPO

0x00bf, 0x00c0, 0x00c1, 0x00e1, 0x00e2, 0x00eb, 0x01af, 0x01bc

SEDOC_ROLOC
SEGAPEDOC
SEILIMAF_TNOF
SELYTS_ENIL_REDROB_FX
SEPYT_ENILREDNU
SEPYT_TNEMEPACSE
SGNIDOCNE_TNOF
SST_CHUNKSIZE
TWIPS
UNDERLINE_TYPES
XF_BORDER_LINE_STYLES

border line styles taken from www.openoffice.org/sc/excelfileformat.pdf

XF_H_ALIGN
XF_TEXT_DIRECTION
XF_V_ALIGN

Public Instance Methods

binfmt(key) click to toggle source
# File lib/spreadsheet/excel/internals.rb, line 439
def binfmt key
  BINARY_FORMATS[key]
end
opcode(key) click to toggle source
# File lib/spreadsheet/excel/internals.rb, line 442
def opcode key
  OPCODES[key]
end

[Validate]

Generated with the Darkfish Rdoc Generator 2.