summaryrefslogtreecommitdiffhomepage
path: root/examples/example.rb
diff options
context:
space:
mode:
authorJurriaan Pruis <[email protected]>2012-03-03 14:52:26 +0100
committerJurriaan Pruis <[email protected]>2012-03-21 13:37:43 +0100
commit4889df8a7702c16bee284a9dffa33bdb8abaa55a (patch)
tree36df335f4d0990d21d542cd9c1aa6d19dd7237ca /examples/example.rb
parente685db85b4ca1ccebaacd66e30545060db08fdc9 (diff)
downloadcaxlsx-4889df8a7702c16bee284a9dffa33bdb8abaa55a.tar.gz
caxlsx-4889df8a7702c16bee284a9dffa33bdb8abaa55a.zip
Updated example
Diffstat (limited to 'examples/example.rb')
-rw-r--r--examples/example.rb14
1 files changed, 13 insertions, 1 deletions
diff --git a/examples/example.rb b/examples/example.rb
index d834a51c..2191f6a6 100644
--- a/examples/example.rb
+++ b/examples/example.rb
@@ -206,6 +206,18 @@ wb.add_worksheet(:name => "Auto Filter") do |sheet|
sheet.auto_filter = "A2:D5"
end
+##Tables
+
+wb.add_worksheet(:name => "Table") do |sheet|
+ sheet.add_row ["Build Matrix"]
+ sheet.add_row ["Build", "Duration", "Finished", "Rvm"]
+ sheet.add_row ["19.1", "1 min 32 sec", "about 10 hours ago", "1.8.7"]
+ sheet.add_row ["19.2", "1 min 28 sec", "about 10 hours ago", "1.9.2"]
+ sheet.add_row ["19.3", "1 min 35 sec", "about 10 hours ago", "1.9.3"]
+ sheet.add_table "A2:D5", :name => 'Build Matrix'
+end
+
+
##Specifying Column Widths
wb.add_worksheet(:name => "custom column widths") do |sheet|
@@ -235,7 +247,7 @@ end
##Validate and Serialize
-p.validate.each { |e| puts e.message }
+#p.validate.each { |e| puts e.message }
p.serialize("example.xlsx")
s = p.to_stream()