blob: 60b3010f751ca94268119ad159217f4f15822611 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
#!/usr/bin/env ruby -w -s
# -*- coding: utf-8 -*-
$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
#```ruby
require 'axlsx'
p = Axlsx::Package.new
p.use_shared_strings = true
s = p.workbook.add_worksheet(:name => "Formula test")
s.add_row [1, 2, 3]
s.add_row %w(a b c)
s.add_row ["=SUM(A1:C1)"], :formula_values => [6]
p.serialize "ios_preview.xlsx"
|
