Skip to content

Instantly share code, notes, and snippets.

@noeticpenguin
Created July 30, 2013 14:31
Show Gist options
  • Save noeticpenguin/6113432 to your computer and use it in GitHub Desktop.
Save noeticpenguin/6113432 to your computer and use it in GitHub Desktop.
style with sheet.
wb.styles do |s|
header = s.add_style :fg_color=> "FFFFFF",
:b => true,
:bg_color => "004586",
:sz => 12,
:border => { :style => :thin, :color => "00" },
:alignment => { :horizontal => :center,
:vertical => :center ,
:wrap_text => true}
end
#cover sheet
wb.add_worksheet(name: "Object Overview") do |sheet|
sheet.add_row obj_headers #probably should enbolden this or something.
@cached_objects.each do |c|
row = Array.new
obj_headers.each do |h|
row << c.read_attribute(h) unless obj_prop_to_skip.include?(h)
end
sheet.add_row row, :style=>header
end
#Hide the url column
sheet.column_info[obj_headers.index('urls')].hidden = true
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment