Sha256: b942d6b0e42b2aaf44f25114280f76b282034935847abc54520ab2d96b3e3b8d
Contents?: true
Size: 1015 Bytes
Versions: 29
Compression:
Stored size: 1015 Bytes
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionTutorial01 < Test::Unit::TestCase
def setup
setup_dir_var
end
def teardown
File.delete(@xlsx) if File.exist?(@xlsx)
end
def test_tutorial01
@xlsx = 'tutorial01.xlsx'
workbook = WriteXLSX.new(@xlsx)
worksheet = workbook.add_worksheet
expenses = [
['Rent', 1000],
['Gas', 100],
['Food', 300],
['Gym', 50]
]
expenses.each_with_index do |item, index|
worksheet.write(index, 0, item[0])
worksheet.write(index, 1, item[1])
end
worksheet.write(expenses.size, 0, 'Total')
worksheet.write(expenses.size, 1, '=SUM(B1:B4)', nil, 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