def test_print_formula_cell_text(self): ''' Test correct formatting of a formula cell with string value ''' xml = '''<c r="E7"><f ca="1">E6+$C$6</f><v>"This is a string"</v></c>''' cell = self.setup(xml) string = print_cells(cell) tools.assert_equal(string, "fo E7 = E6+$C$6 This is a string")
def test_print_formula_cell_value(self): ''' Test correct formatting of a formula cell with numerical value ''' xml = '''<c r="E7"><f ca="1">E6+$C$6</f><v>4.45</v></c>''' cell = self.setup(xml) string = print_cells(cell) tools.assert_equal(string, "fo E7 = E6+$C$6 4.45")
def test(self): """ Opens the test workbook and checks the print out matches the content """ filename = "tests/test1.xlsx" sheets = list(get_worksheets(filename)) string_dict = get_shared_strings("xl/sharedStrings.xml") sheet = sheets[0] output, shared_formulas = parse_worksheet(sheet, string_dict) post_process(output, shared_formulas, string_dict) tools.assert_equal(print_cells(output), "st A1 Hello World")
def test_print_value_cell(self): xml = '''<c r="A3"><v>9.48</v></c>''' cell = self.setup(xml) string = print_cells(cell) tools.assert_equal(string, "va A3 9.48")