module 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
- SEITILIBISIV_TEEHSKROW
- SELYTS_ENIL_REDROB_FX
- SEPYT_ENILREDNU
- SEPYT_TNEMEPACSE
- SGNIDOCNE_TNOF
- SST_CHUNKSIZE
- TWIPS
- UNDERLINE_TYPES
- WORKSHEET_VISIBILITIES
- 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
# File lib/spreadsheet/excel/internals.rb, line 451 def binfmt key BINARY_FORMATS[key] end
# File lib/spreadsheet/excel/internals.rb, line 454 def opcode key OPCODES[key] end