lundi 28 septembre 2015

how we can add the background color in full sheet using axlsx gem?

Here is my code and I want to add background color in full sheet not in a specific row or column.

xlsx_package = Axlsx::Package.new
   wb = xlsx_package.workbook
wb.add_worksheet(:name => "Basic Worksheet") do |sheet|
  sheet.add_row ["First Column", "Second", "Third"]
  sheet.add_row [1, 2, 3]
end

Any help will be appreciated! Thank you.

Aucun commentaire:

Enregistrer un commentaire