def test_simple_styles(datadir): import datetime from ..protection import Protection from .. import numbers from ..stylesheet import write_stylesheet wb = Workbook() wb._colors = () ws = wb.active now = datetime.date.today() for idx, v in enumerate( ['12.34%', now, 'This is a test', '31.31415', None], 1): ws.append([v]) _ = ws.cell(column=1, row=idx).style_id # set explicit formats ws['D9'].number_format = numbers.FORMAT_NUMBER_00 ws['D9'].protection = Protection(locked=True) ws['D9'].style_id ws['E1'].protection = Protection(hidden=True) ws['E1'].style_id assert len(wb._cell_styles) == 4 stylesheet = write_stylesheet(wb) datadir.chdir() with open('simple-styles.xml') as reference_file: expected = reference_file.read() xml = tostring(stylesheet) diff = compare_xml(xml, expected) assert diff is None, diff
def test_write_worksheet(Stylesheet): wb = Workbook() wb._colors = ( '00000000', '00FFFFFF', ) from ..stylesheet import write_stylesheet node = write_stylesheet(wb) xml = tostring(node) expected = """ <styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <numFmts count="0" /> <fonts count="1"> <font> <name val="Calibri"></name> <family val="2"></family> <color theme="1"></color> <sz val="11"></sz> <scheme val="minor"></scheme> </font> </fonts> <fills count="2"> <fill> <patternFill></patternFill> </fill> <fill> <patternFill patternType="gray125"></patternFill> </fill> </fills> <borders count="1"> <border> <left></left> <right></right> <top></top> <bottom></bottom> <diagonal></diagonal> </border> </borders> <cellStyleXfs count="1"> <xf borderId="0" fillId="0" fontId="0" numFmtId="0"></xf> </cellStyleXfs> <cellXfs count="1"> <xf borderId="0" fillId="0" fontId="0" numFmtId="0" pivotButton="0" quotePrefix="0" xfId="0"></xf> </cellXfs> <cellStyles count="1"> <cellStyle builtinId="0" hidden="0" name="Normal" xfId="0"></cellStyle> </cellStyles> <tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleLight16"/> <colors> <indexedColors> <rgbColor rgb="00000000"></rgbColor> <rgbColor rgb="00FFFFFF"></rgbColor> </indexedColors> </colors> </styleSheet> """ diff = compare_xml(xml, expected) assert diff is None, diff