'Test worksheet selection and activation.'

def test_create_file_in_memory(self):

    workbook = Workbook(self.got_filename, {'in_memory': True})
    worksheet1 = workbook.add_worksheet()
    worksheet2 = workbook.add_worksheet('Data    Sheet')
    worksheet3 = workbook.add_worksheet()
    bold = workbook.add_format({'bold': 1})
    worksheet1.write('A1', 'Foo')
    worksheet1.write('A2', 123)
    worksheet3.write('B2', 'Foo')
    worksheet3.write('B3', 'Bar', bold)
    worksheet3.write('C4', 234)
    worksheet2.activate()
    worksheet2.select()
    worksheet3.select()
    worksheet3.activate()
    workbook.close()
    self.assertExcelEqual()
