#NEWLINE# def test_assemble_xml_file( self ) : #NEWLINE# #INDENT# 'Test writing a worksheet with conditional formatting.' #NEWLINE# self . maxDiff = None #NEWLINE# fh = StringIO ( ) #NEWLINE# worksheet = Worksheet ( ) #NEWLINE# worksheet . _set_filehandle ( fh ) #NEWLINE# worksheet . select ( ) #NEWLINE# worksheet . write ( 'A1' , 10 ) #NEWLINE# worksheet . write ( 'A2' , 20 ) #NEWLINE# worksheet . write ( 'A3' , 30 ) #NEWLINE# worksheet . write ( 'A4' , 40 ) #NEWLINE# date = datetime . strptime ( '2011-01-01' , '%Y-%m-%d' ) #NEWLINE# worksheet . conditional_format ( 'A1:A4' , { #NEWLINE# #INDENT# 'type' : 'date' , #NEWLINE# 'criteria' : 'greater than' , #NEWLINE# 'value' : date , #NEWLINE# 'format' : None , #NEWLINE# #UNINDENT# } ) #NEWLINE# worksheet . _assemble_xml_file ( ) #NEWLINE# exp = _xml_to_list ( '\n                <?xml version="1.0" encoding="UTF-8" standalone="yes"?>\n                <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">\n                  <dimension ref="A1:A4"/>\n                  <sheetViews>\n                    <sheetView tabSelected="1" workbookViewId="0"/>\n                  </sheetViews>\n                  <sheetFormatPr defaultRowHeight="15"/>\n                  <sheetData>\n                    <row r="1" spans="1:1">\n                      <c r="A1">\n                        <v>10</v>\n                      </c>\n                    </row>\n                    <row r="2" spans="1:1">\n                      <c r="A2">\n                        <v>20</v>\n                      </c>\n                    </row>\n                    <row r="3" spans="1:1">\n                      <c r="A3">\n                        <v>30</v>\n                      </c>\n                    </row>\n                    <row r="4" spans="1:1">\n                      <c r="A4">\n                        <v>40</v>\n                      </c>\n                    </row>\n                  </sheetData>\n                  <conditionalFormatting sqref="A1:A4">\n                    <cfRule type="cellIs" priority="1" operator="greaterThan">\n                      <formula>40544</formula>\n                    </cfRule>\n                  </conditionalFormatting>\n                  <pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/>\n                </worksheet>\n                ' ) #NEWLINE# got = _xml_to_list ( fh . getvalue ( ) ) #NEWLINE# self . assertEqual ( self , exp )