From 7d288efdc175dd9db030ada073aab360ea1b6b95 Mon Sep 17 00:00:00 2001 From: Jonathan Tron Date: Wed, 22 Feb 2012 18:56:53 +0100 Subject: Add :date support to Axlsx::Cell and add missing part for boolean support - date is now separated from Time support so that it does not include unwanted hours/minutes/seconds - missing boolean support was the xml generation specific to :boolean type --- examples/example.rb | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'examples/example.rb') 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| -- cgit v1.2.3