def test_plain_cell(self): ''' Test correct reading of plain shared string ''' xml = '''<si><t>Pig iron production</t></si>''' row = self.setup(xml) output = process_shared_string_row(row) tools.assert_equal(output, "Pig iron production")
def test_small_formatted_cell(self): ''' Test correct reading of small formatted shared string ''' xml = '''<si><t>Non-metallic minerals (cem proxy)</t><phoneticPr fontId="29" type="noConversion"/></si>''' row = self.setup(xml) output = process_shared_string_row(row) tools.assert_equal(output, "Non-metallic minerals (cem proxy)")
def test_formatted_cell(self): ''' Test correct reading of formatted shared string ''' xml = '''<si> <r> <t>Preparation for AR5</t> </r> <r> <rPr> <sz val="11"/> <color theme="1"/> <rFont val="Calibri"/> <family val="2"/> <scheme val="minor"/> </rPr> <t xml:space="preserve"> (see other file):</t> </r> </si>''' row = self.setup(xml) output = process_shared_string_row(row) tools.assert_equal(output, "Preparation for AR5 (see other file):")