Method: Axlsx::ConditionalFormatting#to_xml_string

Defined in:
lib/axlsx/workbook/worksheet/conditional_formatting.rb

#to_xml_string(str = '') ⇒ String

Serializes the conditional formatting element

Examples:

Conditional Formatting XML looks like:

<conditionalFormatting sqref="E3:E9">
    <cfRule type="cellIs" dxfId="0" priority="1" operator="greaterThan">
         <formula>0.5</formula>
    </cfRule>
</conditionalFormatting>

Parameters:

  • str (String) (defaults to: '')

Returns:

  • (String) 


76
77
78
79
80
 
# File 'lib/axlsx/workbook/worksheet/conditional_formatting.rb', line 76

def to_xml_string(str = '')
  str << ('<conditionalFormatting sqref="' << sqref << '">')
  str << rules.collect{ |rule| rule.to_xml_string }.join(' ')
  str << '</conditionalFormatting>'
end