From 0df1bc655f5e6bfa0a6f89b7517a74a2cfaffc87 Mon Sep 17 00:00:00 2001 From: Jan-Hendrik Hühne Date: Tue, 22 May 2012 13:41:11 +0200 Subject: First try of the data validation feature. --- examples/data_validations.rb | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 examples/data_validations.rb (limited to 'examples') 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' -- cgit v1.2.3