def test2():
val = datetime.strptime('1/1/2020', '%m/%d/%Y')
self.assertIsInstance(val, datetime)
ExcelWriter._setFormatting(currCell, val)
self.assertEqual('yyyy-mm-dd', currCell.number_format)
def test3():
val = 'abc'
self.assertIsInstance(val, str)
ExcelWriter._setFormatting(currCell, val)
self.assertEqual('@', currCell.number_format)
def test1():
val = 1
self.assertIsInstance(val, int)
ExcelWriter._setFormatting(currCell, val)
self.assertEqual('0', currCell.number_format)