def test_lots_cols(write_cols, ColumnDimension, DummyWorksheet): from openpyxl.styles import Font ws = DummyWorksheet from openpyxl.cell import get_column_letter for i in range(1, 15): label = get_column_letter(i) cd = ColumnDimension(worksheet=ws) cd.font = Font(name=label) dict(cd) # create style_id in order for test ws.column_dimensions[label] = cd cols = write_cols(ws) xml = tostring(cols) expected = """<cols> <col max="1" min="1" style="1"></col> <col max="2" min="2" style="2"></col> <col max="3" min="3" style="3"></col> <col max="4" min="4" style="4"></col> <col max="5" min="5" style="5"></col> <col max="6" min="6" style="6"></col> <col max="7" min="7" style="7"></col> <col max="8" min="8" style="8"></col> <col max="9" min="9" style="9"></col> <col max="10" min="10" style="10"></col> <col max="11" min="11" style="11"></col> <col max="12" min="12" style="12"></col> <col max="13" min="13" style="13"></col> <col max="14" min="14" style="14"></col> </cols> """ diff = compare_xml(xml, expected) assert diff is None, diff
def test_col_style(write_cols, ColumnDimension, DummyWorksheet): from openpyxl.styles import Font ws = DummyWorksheet cd = ColumnDimension(worksheet=ws) ws.column_dimensions['A'] = cd cd.font = Font(color="FF0000") cols = write_cols(ws) xml = tostring(cols) expected = """<cols><col max="1" min="1" style="1"></col></cols>""" diff = compare_xml(xml, expected) assert diff is None, diff