summaryrefslogtreecommitdiffhomepage
path: root/examples/example.rb
diff options
context:
space:
mode:
Diffstat (limited to 'examples/example.rb')
-rw-r--r--examples/example.rb9
1 files changed, 9 insertions, 0 deletions
diff --git a/examples/example.rb b/examples/example.rb
index cedf4ace..2d60a474 100644
--- a/examples/example.rb
+++ b/examples/example.rb
@@ -113,6 +113,15 @@
sheet.add_row [1, 2, 3, "=SUM(A2:C2)"]
end
+##Automatic cell types
+
+ wb.add_worksheet(:name => "Automatic cell types") do |sheet|
+ t = Time.now
+ sheet.add_row ["Date", "Time", "String", "Boolean", "Float", "Integer"]
+ sheet.add_row [Date.today, t, "value", true, 0.1, 1]
+ sheet.add_row ["", t.to_f, "", "", "", ""]
+ end
+
##Merging Cells.
wb.add_worksheet(:name => 'Merging Cells') do |sheet|