Python Cell.bind_value Examples

Example #1

File: test_cell.py Project: chronossc/openpyxl

def test_data_type_check():
    cell = Cell(None, '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)

Example #2

File: test_cell.py Project: wangzhengbo1204/Python

def test_data_type_check():
    cell = Cell(None, "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)

Example #3

def test_data_type_check():
    cell = Cell(None, '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)

Example #4

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)

Example #5

File: test_cell.py Project: waitalone/openpyxl

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)

Example #6

File: test_cell.py Project: kamilgrymuza/openpyxl

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)

Example #7

File: test_cell.py Project: emilevictor/ccsrch.py

def test_data_type_check():
    class Ws(object):
            encoding = 'utf-8'
    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)

Example #8

File: test_cell.py Project: btolab/ccsrch.py

def test_data_type_check():
    class Ws(object):
        encoding = 'utf-8'

    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)

Example #9

File: test_cell.py Project: ZhouX1ang/xls2proto

def test_data_type_check():
    class Ws(object):
        encoding = "utf-8"

    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)

Example #10

File: test_cell.py Project: PREM1980/onlineshop

def test_data_type_check(value, datatype):
    ws = build_dummy_worksheet()
    ws.parent._guess_types = True
    cell = Cell(ws, 'A', 1)
    cell.bind_value(value)
    assert cell.data_type == datatype

Example #11

File: test_cell.py Project: tongjianjun/openpyxl

def test_data_type_check(value, datatype):
    ws = build_dummy_worksheet()
    ws.parent._guess_types = True
    cell = Cell(ws, 'A', 1)
    cell.bind_value(value)
    assert cell.data_type == datatype