Contents

# -*- coding: utf-8 -*-
require 'helper'

class TestWorksheeByName < Minitest::Test
  def test_worksheet_by_name
    io = StringIO.new
    workbook = WriteXLSX.new(io)

    # Test a valid explicit name.
    expected = workbook.add_worksheet
    result   = workbook.worksheet_by_name('Sheet1')
    assert_equal(expected, result)
    result   = workbook.get_worksheet_by_name('Sheet1')
    assert_equal(expected, result)

    # Test a valid explicit name.
    expected = workbook.add_worksheet('Sheet 2')
    result   = workbook.worksheet_by_name('Sheet 2')
    assert_equal(expected, result)
    result   = workbook.get_worksheet_by_name('Sheet 2')
    assert_equal(expected, result)

    # Test an invalid name.
    result   = workbook.worksheet_by_name('Sheet3')
    assert_nil(result)
    result   = workbook.get_worksheet_by_name('Sheet3')
    assert_nil(result)

    # Test an invalid name.
    result   = workbook.worksheet_by_name()
    assert_nil(result)
    result   = workbook.get_worksheet_by_name()
    assert_nil(result)
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
write_xlsx-1.09.4	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.09.3	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.09.2	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.09.1	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.09.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.08.2	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.08.1	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.08.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.07.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.04.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.02.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.01.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-1.00.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-0.99.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-0.97.0	test/workbook/test_worksheet_by_name.rb
write_xlsx-0.90.0	test/workbook/test_worksheet_by_name.rb