def test_set_get_date(): today = datetime(2010, 1, 18, 14, 15, 20, 1600) wb = Workbook() ws = Worksheet(wb) cell = Cell(ws, 'A', 1) cell.value = today eq_(today, cell.value)
def test_date_format_on_non_date(): wb = Workbook() ws = Worksheet(wb) cell = Cell(ws, 'A', 1) cell.value = datetime.now() cell.value = 'testme' eq_('testme', cell.value)
def test_timedelta(): wb = Workbook() ws = Worksheet(wb) cell = Cell(ws, 'A', 1) cell.value = timedelta(days=1, hours=3) eq_(cell.value, 1.125) eq_(cell.TYPE_NUMERIC, cell.data_type)
def test_is_not_date_color_format(): wb = Workbook() ws = Worksheet(wb) cell = Cell(ws, 'A', 1) cell.value = -13.5 cell.style.number_format.format_code = '0.00_);[Red]\(0.00\)' assert cell.is_date() is False
def test_data_type_check(): ws = build_dummy_worksheet() cell = Cell(ws, 'A', 1) cell.bind_value(None) eq_(Cell.TYPE_NULL, cell._data_type) cell.bind_value('.0e000') eq_(Cell.TYPE_NUMERIC, cell._data_type) cell.bind_value('-0.e-0') eq_(Cell.TYPE_NUMERIC, cell._data_type) cell.bind_value('1E') eq_(Cell.TYPE_STRING, cell._data_type)
def test_is_date(): wb = Workbook() ws = Worksheet(wb) cell = Cell(ws, 'A', 1) cell.value = datetime.now() eq_(cell.is_date(), True) cell.value = 'testme' eq_('testme', cell.value) assert cell.is_date() is False
def test_time(): def check_time(raw_value, coerced_value): cell.value = raw_value eq_(cell.value, coerced_value) eq_(cell.TYPE_NUMERIC, cell.data_type) wb = Workbook() ws = Worksheet(wb) cell = Cell(ws, 'A', 1) values = ( ('03:40:16', time(3, 40, 16)), ('03:40', time(3, 40)), ) for raw_value, coerced_value in values: yield check_time, raw_value, coerced_value
def test_repr(): wb = Workbook() ws = Worksheet(wb) cell = Cell(ws, 'A', 1) eq_(repr(cell), '<Cell Sheet1.A1>', 'Got bad repr: %s' % repr(cell))
def test_set_bad_type(): ws = build_dummy_worksheet() cell = Cell(ws, 'A', 1) cell.set_explicit_value(1, 'q')
def setup_class(cls): ws = build_dummy_worksheet() cls.cell = Cell(ws, 'A', 1)
def test_initial_value(): ws = build_dummy_worksheet() cell = Cell(ws, 'A', 1, value='17.5') eq_(cell.TYPE_NUMERIC, cell.data_type)