Sha256: 1186e9d8e1005eb0ed4f29d5e97fbcd320756e9548d3f5fb5f5d3e0b306f155b
Contents?: true
Size: 1.46 KB
Versions: 19
Compression:
Stored size: 1.46 KB
Contents
# -*- coding: utf-8 -*-
require 'helper'
class TestRegressionTable13 < Minitest::Test
def setup
setup_dir_var
end
def teardown
@tempfile.close(true)
end
def test_table13
@xlsx = 'table13.xlsx'
workbook = WriteXLSX.new(@io)
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_for_regression(
nil,
{ 'xl/workbook.xml' => ['<workbookView'] }
)
end
end
Version data entries
19 entries across 19 versions & 1 rubygems