Method: RubyXL::WorksheetConvenienceMethods#change_column_fill

Defined in:
lib/rubyXL/convenience_methods/worksheet.rb

#change_column_fill(column_index, color_code = 'ffffff') ⇒ Object 



401
402
403
404
405
406
407
408
409
410
411
412
413
414
 
# File 'lib/rubyXL/convenience_methods/worksheet.rb', line 401

def change_column_fill(column_index, color_code = 'ffffff')
  validate_workbook
  RubyXL::Color.validate_color(color_code)
  ensure_cell_exists(0, column_index)

  cols.get_range(column_index).style_index = @workbook.modify_fill(get_col_style(column_index), color_code)

  sheet_data.rows.each { |row|
    next if row.nil?
    c = row[column_index]
    next if c.nil?
    c.change_fill(color_code)
  }
end