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)