blob: 84677066d5e9d7c05811769ed5f41e9d866d6790 (
plain)
1
2
3
4
5
6
7
8
9
10
11
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'
|
