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
