spreadsheet-colorindex.rb

require 'spreadsheet'

# Code to add integer keys and Excel colorindex codes to
# ruby-spreadsheet's Font and Format api.
# eg. Spreadsheet::Format.new :color => 1

module Spreadsheet::Excel::Internals
  (1..56).collect { |i| SEDOC_ROLOC[i.to_s.to_sym] = i + 7 }
end

class << Spreadsheet::Font
  (1..56).each { |i| COLORS << i.to_s.to_sym }
end

class << Spreadsheet::Format
  (1..56).each { |i| COLORS << i.to_s.to_sym }
end