'Test dates and times in A1 notation.'

def test_create_file_A1(self):

    workbook = Workbook(self.got_filename)
    worksheet = workbook.add_worksheet()
    worksheet.set_column('A:A', 12)
    format1 = workbook.add_format({'num_format': 20})
    format2 = workbook.add_format({'num_format': 14})
    date1 = datetime.strptime('12:00', '%H:%M')
    date2 = datetime.strptime('2013-01-27', '%Y-%m-%d')
    worksheet.write_datetime('A1', date1, format1)
    worksheet.write_datetime('A2', date2, format2)
    workbook.close()
    self.assertExcelEqual()
