adding in option to show/hide gridlines in a sheet.

1 files changed, 7 insertions, 0 deletions

diff --git a/examples/example.rb b/examples/example.rb
index 8058b50b..df5a401f 100644
--- a/examples/example.rb
+++ b/examples/example.rb
@@ -201,6 +201,13 @@ wb.add_worksheet(:name => "custom column widths") do |sheet|
   sheet.column_widths nil, 3
 end
 
+
+##Hide Gridlines in worksheet
+wb.add_worksheet(:name => "No Gridlines") do |sheet|
+  sheet.add_row ["This", "Sheet", "Hides", "Gridlines"]
+  sheet.show_gridlines = false
+end
+
 ##Specify Page Margins for printing
 margins = {:left => 3, :right => 3, :top => 1.2, :bottom => 1.2, :header => 0.7, :footer => 0.7}
 wb.add_worksheet(:name => "print margins", :page_margins => margins) do |sheet|