Sha256: 67aa80646fda469ee3a3b2b47f6d9619631ffec0a39c35f9d065f40bf9e340eb
Contents?: true
Size: 946 Bytes
Versions: 12
Compression:
Stored size: 946 Bytes
Contents
#!/usr/bin/env ruby
# -*- coding: utf-8 -*-
#######################################################################
#
# Example of how to use the WriteXLSX gem to write simple
# array formulas.
#
# reverse(c), August 2004, John McNamara, jmcnamara@cpan.org
# convert to ruby by Hideo NAKAMURA, nakamura.hideo@gmail.com
#
require 'write_xlsx'
# Create a new workbook and add a worksheet
workbook = WriteXLSX.new('array_formula.xlsx')
worksheet = workbook.add_worksheet
# Write some test data.
worksheet.write('B1', [ [ 500, 10 ], [ 300, 15 ] ])
worksheet.write('B5', [ [ 1, 2, 3 ], [ 20234, 21003, 10000 ] ])
# Write an array formula that returns a single value
worksheet.write('A1', '{=SUM(B1:C1*B2:C2)}')
# Same as above but more verbose.
worksheet.write_array_formula('A2:A2', '{=SUM(B1:C1*B2:C2)}')
# Write an array formula that returns a range of values
worksheet.write_array_formula('A5:A7', '{=TREND(C5:C7,B5:B7)}')
workbook.close
Version data entries
12 entries across 12 versions & 1 rubygems