Method: GoogleDrive::Worksheet#set_background_color

Defined in:
lib/google_drive/worksheet.rb

#set_background_color(top_row, left_col, num_rows, num_cols, background_color) ⇒ Object

Changes the background color on a range of cells. e.g.:

worksheet.set_background_color(1, 1, 1, 1, GoogleDrive::Worksheet::Colors::DARK_YELLOW_1)

background_color is an instance of Google::Apis::SheetsV4::Color.



592
593
594
595
596
 
# File 'lib/google_drive/worksheet.rb', line 592

def set_background_color(top_row, left_col, num_rows, num_cols, background_color)
  format = Google::Apis::SheetsV4::CellFormat.new(background_color: background_color)
  fields = 'userEnteredFormat(backgroundColor)'
  format_cells(top_row, left_col, num_rows, num_cols, format, fields)
end