Sha256: efc3bab5cdf728f148f43b4266fa1f6f384841bd0f46e33c1ac53b9156e79556
Contents?: true
Size: 1.46 KB
Versions: 19
Compression:
Stored size: 1.46 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionTutorial03 < Minitest::Test
def setup
setup_dir_var
end
def teardown
@tempfile.close(true)
end
def test_tutorial03
@xlsx = 'tutorial03.xlsx'
workbook = WriteXLSX.new(@io)
worksheet = workbook.add_worksheet
bold = workbook.add_format(:bold => 1)
money_format = workbook.add_format(:num_format => '\\$#,##0')
date_format = workbook.add_format(:num_format => 'mmmm\\ d\\ yyyy')
worksheet.set_column('B:B', 15)
worksheet.write('A1', 'Item', bold)
worksheet.write('B1', 'Date', bold)
worksheet.write('C1', 'Cost', bold)
expenses = [
[ 'Rent', '2013-01-13T', 1000 ],
[ 'Gas', '2013-01-14T', 100 ],
[ 'Food', '2013-01-16T', 300 ],
[ 'Gym', '2013-01-20T', 50 ]
]
expenses.each_with_index do |item, index|
worksheet.write_string(index + 1, 0, item[0])
worksheet.write_date_time(index + 1, 1, item[1], date_format)
worksheet.write_number(index + 1, 2, item[2], money_format)
end
worksheet.write(expenses.size + 1, 0, 'Total', bold)
worksheet.write(expenses.size + 1, 2, '=SUM(C2:C5)', money_format, 1450)
workbook.close
compare_for_regression(
['xl/calcChain.xml', '[Content_Types].xml', 'xl/_rels/workbook.xml.rels'],
{}
)
end
end
Version data entries
19 entries across 19 versions & 1 rubygems