summaryrefslogtreecommitdiffhomepage
path: root/examples
diff options
context:
space:
mode:
authorJan-Hendrik Hühne <[email protected]>2012-05-22 13:41:11 +0200
committerJan-Hendrik Hühne <[email protected]>2012-05-22 13:41:11 +0200
commit0df1bc655f5e6bfa0a6f89b7517a74a2cfaffc87 (patch)
tree98aa3032f10c786d6d2ef2a10f57c50911bff81f /examples
parent745a47bf2a7f90e8538d011481979e3e57761787 (diff)
downloadcaxlsx-0df1bc655f5e6bfa0a6f89b7517a74a2cfaffc87.tar.gz
caxlsx-0df1bc655f5e6bfa0a6f89b7517a74a2cfaffc87.zip
First try of the data validation feature.
Diffstat (limited to 'examples')
-rw-r--r--examples/data_validations.rb12
1 files changed, 12 insertions, 0 deletions
diff --git a/examples/data_validations.rb b/examples/data_validations.rb
new file mode 100644
index 00000000..84677066
--- /dev/null
+++ b/examples/data_validations.rb
@@ -0,0 +1,12 @@
+#!/usr/bin/env ruby -w -s
+# -*- coding: utf-8 -*-
+$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
+require 'axlsx'
+
+p = Axlsx::Package.new
+p.workbook.add_worksheet do |ws|
+ data_validation_1 = { :type => :whole, :formula1 => '4', :formula2 => '10'}
+
+ ws.add_data_validation("A1", data_validation_1)
+end
+p.serialize 'data_validations.xlsx'