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)'
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)')
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)")
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)'
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)'
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)"
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