Sha256: 828c946d53f38975c80f1e9a3543ad8e6c6e50c3715bea13549f84748aa4e15f
Contents?: true
Size: 1.54 KB
Versions: 42
Compression:
Stored size: 1.54 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionTable13 < Test::Unit::TestCase
def setup
setup_dir_var
end
def teardown
File.delete(@xlsx) if File.exist?(@xlsx)
end
def test_table13
@xlsx = 'table13.xlsx'
workbook = WriteXLSX.new(@xlsx)
worksheet = workbook.add_worksheet
format1 = workbook.add_format(:num_format => 2, :dxf_index => 2)
format2 = workbook.add_format(:num_format => 2, :dxf_index => 1)
format3 = workbook.add_format(:num_format => 2, :dxf_index => 0)
data = [
[ 'Foo', 1234, 2000, 4321 ],
[ 'Bar', 1256, 4000, 4320 ],
[ 'Baz', 2234, 3000, 4332 ],
[ 'Bop', 1324, 1000, 4333 ]
]
# Set the column width to match the taget worksheet.
worksheet.set_column('C:F', 10.288)
# Add the table.
worksheet.add_table(
'C2:F6',
{
:data => data,
:columns => [
{},
{:format => format1},
{:format => format2},
{:format => format3}
]
}
)
workbook.close
compare_xlsx_for_regression(File.join(@regression_output, @xlsx), @xlsx,
nil,
{ 'xl/workbook.xml' => ['<workbookView'] }
)
end
end
Version data entries
42 entries across 42 versions & 1 rubygems