def test_get_sheet(self):
"""
Test that accessing a sheet that doesn't exists return None and not throw an exception
"""
wb = Workbook()
wb.create_sheet(0, 'Test')
self.assertTrue('Test' in utils.get_sheet_titles(wb))
ws = utils.get_sheet(wb, 'Test')
self.assertIsNotNone(ws)
wb.remove_sheet(ws)
self.assertIsNone(utils.get_sheet(wb, 'Test'))
def test_get_sheet_case_insensitive(self):
"""
By default it is case insensitive
"""
wb = Workbook()
wb.create_sheet(0, 'Test')
self.assertTrue('Test' in utils.get_sheet_titles(wb))
ws = utils.get_sheet(wb, 'test')
self.assertIsNotNone(ws)
self.assertIsNone(utils.get_sheet(wb, 'test', case_insensitive=False))
wb.remove_sheet(ws)
self.assertIsNone(utils.get_sheet(wb, 'test'))
