def test_empty_cell(self):
sheet = self.book.sheet_by_name('TRAVERSALCHAINAGE')
cell = sheet.cell(0, 0)
self.assertEqual(cell.ctype, xlrd.book.XL_CELL_EMPTY)
self.assertEqual(cell.value, '')
self.assertEqual(type(cell.value), type(UNICODE_LITERAL('')))
self.assertTrue(cell.xf_index > 0)
def test_string_cell(self):
cell = self.sheet.cell(0, 0)
self.assertEqual(cell.ctype, xlrd.book.XL_CELL_TEXT)
self.assertEqual(cell.value, 'PROFIL')
self.assertEqual(type(cell.value), type(UNICODE_LITERAL('')))
self.assertTrue(cell.xf_index > 0)