def test_write_no_ascii(self, ten_row_sheet, Series, BarChart, Reference, root_xml): ws = ten_row_sheet ws.append([b"D\xc3\xbcsseldorf"]*10) serie = Series(values=Reference(ws, (1,1), (1,10)), title=(ws.cell(row=1, column=1).value) ) c = BarChart() c.add_serie(serie) cw = BaseChartWriter(c) cw._write_series(root_xml) xml = tostring(root_xml) expected = """ <test> <c:ser xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart"> <c:idx val="0"/> <c:order val="0"/> <c:val> <c:numRef> <c:f>'data'!$A$1:$J$1</c:f> </c:numRef> </c:val> </c:ser> </test> """ diff = compare_xml(xml, expected) assert diff is None, diff
def test_write_serial(ten_row_sheet, LineChart, Series, Reference, root_xml): ws = ten_row_sheet chart = LineChart() for idx, l in enumerate("ABCDEF", 1): ws.cell(row=idx, column=1).value = l ref = Reference(ws, (1, 1), (10, 1)) series = Series(ref) chart.add_serie(series) cw = BaseChartWriter(chart) cw._write_serial(cw.root, ref) xml = tostring(cw.root) expected = """ <c:chartSpace xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart"> <c:strRef> <c:f>'data'!$A$1:$A$10</c:f> </c:strRef> </c:chartSpace> """ diff = compare_xml(xml, expected) assert diff is None, diff