Sha256: 74f7ef87b8797bcbc46e4b494f66a89701df00e1ca2a624bc95bcf2c1b17635a
Contents?: true
Size: 1.21 KB
Versions: 29
Compression:
Stored size: 1.21 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionTutorial02 < Test::Unit::TestCase
def setup
setup_dir_var
end
def teardown
File.delete(@xlsx) if File.exist?(@xlsx)
end
def test_tutorial02
@xlsx = 'tutorial02.xlsx'
workbook = WriteXLSX.new(@xlsx)
worksheet = workbook.add_worksheet
bold = workbook.add_format(:bold => 1)
money = workbook.add_format(:num_format => '\\$#,##0')
worksheet.write('A1', 'Item', bold)
worksheet.write('B1', 'Cost', bold)
expenses = [
['Rent', 1000],
['Gas', 100],
['Food', 300],
['Gym', 50]
]
expenses.each_with_index do |item, index|
worksheet.write(index + 1, 0, item[0])
worksheet.write(index + 1, 1, item[1], money)
end
worksheet.write(expenses.size + 1, 0, 'Total', bold)
worksheet.write(expenses.size + 1, 1, '=SUM(B2:B5)', money, 1450)
workbook.close
compare_xlsx_for_regression(File.join(@regression_output, @xlsx), @xlsx,
['xl/calcChain.xml', '[Content_Types].xml', 'xl/_rels/workbook.xml.rels'],
{}
)
end
end
Version data entries
29 entries across 29 versions & 1 rubygems