Esempi in Python per fast_parse

Esempio n. 1

File: test_read.py Progetto: adammorris/openpyxl

 def test_fast_parse(self):
     from openpyxl.reader.worksheet import fast_parse
     fast_parse(self.ws, self.xml_src, {}, {}, None)
     b1 = self.ws.cell('B1')
     assert b1.data_type == 'f'
     assert b1.value, '=CONCATENATE(A1 == A2)'
     a6 = self.ws.cell('A6')
     assert a6.data_type == 'f'
     assert a6.value == '=SUM(A4:A5)'

Esempio n. 2

File: test_read.py Progetto: Jian-Zhan/customarrayformatter

 def test_fast_parse(self):
     from openpyxl.reader.worksheet import fast_parse
     fast_parse(self.ws, self.xml_src, {}, {}, None)
     b1 = self.ws.cell('B1')
     eq_(b1.data_type, 'f')
     eq_(b1.value, '=CONCATENATE(A1,A2)')
     a6 = self.ws.cell('A6')
     eq_(a6.data_type, 'f')
     eq_(a6.value, '=SUM(A4:A5)')

Esempio n. 3

    def test_fast_parse(self):
        from openpyxl.reader.worksheet import fast_parse

        fast_parse(self.ws, self.xml_src, {}, {}, None)
        b1 = self.ws.cell("B1")
        eq_(b1.data_type, "f")
        eq_(b1.value, "=CONCATENATE(A1,A2)")
        a6 = self.ws.cell("A6")
        eq_(a6.data_type, "f")
        eq_(a6.value, "=SUM(A4:A5)")

Esempio n. 4

File: test_read.py Progetto: dkav/gnarly-landscape-utilities

def test_read_cell_formulae(datadir):
    from openpyxl.reader.worksheet import fast_parse
    datadir.join("reader").chdir()
    wb = Workbook()
    ws = wb.active
    fast_parse(ws, open( "worksheet_formula.xml"), ['', ''], {}, None)
    b1 = ws['B1']
    assert b1.data_type == 'f'
    assert b1.value == '=CONCATENATE(A1,A2)'
    a6 = ws['A6']
    assert a6.data_type == 'f'
    assert a6.value == '=SUM(A4:A5)'

Esempio n. 5

File: test_read.py Progetto: ericgazoni/openpyxl

def test_read_cell_formulae():
    from openpyxl.reader.worksheet import fast_parse
    src_file = os.path.join(DATADIR, "reader", "worksheet_formula.xml")
    wb = Workbook()
    ws = wb.active
    fast_parse(ws, open(src_file), {}, {}, None)
    b1 = ws['B1']
    assert b1.data_type == 'f'
    assert b1.value == '=CONCATENATE(A1,A2)'
    a6 = ws['A6']
    assert a6.data_type == 'f'
    assert a6.value == '=SUM(A4:A5)'

Esempio n. 6

File: test_read.py Progetto: NREL/EnergyPlusValidationReports

def test_read_cell_formulae(datadir):
    from openpyxl.reader.worksheet import fast_parse
    datadir.join("reader").chdir()
    wb = Workbook()
    ws = wb.active
    fast_parse(ws, open( "worksheet_formula.xml"), ['', ''], {}, None)
    b1 = ws['B1']
    assert b1.data_type == 'f'
    assert b1.value == '=CONCATENATE(A1,A2)'
    a6 = ws['A6']
    assert a6.data_type == 'f'
    assert a6.value == '=SUM(A4:A5)'

Esempio n. 7

File: test_read.py Progetto: glezma/risk_return_engine

def test_read_cell_formulae():
    from openpyxl.reader.worksheet import fast_parse
    src_file = os.path.join(DATADIR, "reader", "worksheet_formula.xml")
    wb = Workbook()
    ws = wb.active
    fast_parse(ws, open(src_file), {}, {}, None)
    b1 = ws['B1']
    assert b1.data_type == 'f'
    assert b1.value == '=CONCATENATE(A1,A2)'
    a6 = ws['A6']
    assert a6.data_type == 'f'
    assert a6.value == '=SUM(A4:A5)'

Esempio n. 8

File: test_read.py Progetto: theorchard/openpyxl

def test_read_cell_formulae(datadir):
    from openpyxl.reader.worksheet import fast_parse

    datadir.join("reader").chdir()
    wb = Workbook()
    ws = wb.active
    fast_parse(ws, open("worksheet_formula.xml"), ["", ""], {}, None)
    b1 = ws["B1"]
    assert b1.data_type == "f"
    assert b1.value == "=CONCATENATE(A1,A2)"
    a6 = ws["A6"]
    assert a6.data_type == "f"
    assert a6.value == "=SUM(A4:A5)"

Esempio n. 9

File: test_read.py Progetto: GitContainer/iPython-Framework

def test_read_standalone_worksheet(datadir):
    class DummyWb(object):

        encoding = 'utf-8'

        excel_base_date = CALENDAR_WINDOWS_1900
        _guess_types = True
        data_only = False
        _colors = []
        vba_archive = None

        def __init__(self):
            self.shared_styles = [Style()]
            self._cell_styles = IndexedList()
            self._differential_styles = []
            self.sheetnames = []

        def get_sheet_by_name(self, value):
            return None

        def create_sheet(self, title):
            return Worksheet(self, title=title)

    datadir.join("reader").chdir()
    shared_strings = IndexedList(['hello'])

    with open('sheet2.xml') as src:
        ws = fast_parse(src.read(), DummyWb(), 'Sheet 2', shared_strings)
        assert isinstance(ws, Worksheet)
        assert ws.cell('G5').value == 'hello'
        assert ws.cell('D30').value == 30
        assert ws.cell('K9').value == 0.09

Esempio n. 10

File: test_read.py Progetto: schulzsebastian/qgisplugin_xlsxcoordinates

def test_read_standalone_worksheet(datadir):

    class DummyWb(object):

        encoding = 'utf-8'

        excel_base_date = CALENDAR_WINDOWS_1900
        _guess_types = True
        data_only = False
        _colors = []
        vba_archive = None

        def __init__(self):
            self.shared_styles = [Style()]
            self._cell_styles = IndexedList()
            self._differential_styles = []
            self.sheetnames = []

        def get_sheet_by_name(self, value):
            return None

        def create_sheet(self, title):
            return Worksheet(self, title=title)

    datadir.join("reader").chdir()
    shared_strings = IndexedList(['hello'])

    with open('sheet2.xml') as src:
        ws = fast_parse(src.read(), DummyWb(), 'Sheet 2', shared_strings)
        assert isinstance(ws, Worksheet)
        assert ws.cell('G5').value == 'hello'
        assert ws.cell('D30').value == 30
        assert ws.cell('K9').value == 0.09