How to use the openpyxl.xml.functions.end_tag function in openpyxl
To help you get started, we’ve selected a few openpyxl examples, based on popular ways it is used in public projects.
Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
ericgazoni / openpyxl / openpyxl / writer / worksheet.py View on Github 
'tint': str(color.index).split(':')[2]})
else:
tag(doc, 'color', {'theme': str(color.index).split(':')[1]})
else:
tag(doc, 'color', {'rgb': str(color.index)})
end_tag(doc, 'colorScale')
if 'iconSet' in rule:
iconAttr = {}
for icon_attr in ConditionalFormatting.icon_attributes:
if icon_attr in rule['iconSet']:
iconAttr[icon_attr] = rule['iconSet'][icon_attr]
start_tag(doc, 'iconSet', iconAttr)
for cfvo in rule['iconSet']['cfvo']:
tag(doc, 'cfvo', cfvo)
end_tag(doc, 'iconSet')
end_tag(doc, 'cfRule')
end_tag(doc, 'conditionalFormatting')tag(doc, 'color', {'theme': str(color.index).split(':')[1],
'tint': str(color.index).split(':')[2]})
else:
tag(doc, 'color', {'theme': str(color.index).split(':')[1]})
else:
tag(doc, 'color', {'rgb': str(color.index)})
end_tag(doc, 'colorScale')
if 'iconSet' in rule:
iconAttr = {}
for icon_attr in ConditionalFormatting.icon_attributes:
if icon_attr in rule['iconSet']:
iconAttr[icon_attr] = rule['iconSet'][icon_attr]
start_tag(doc, 'iconSet', iconAttr)
for cfvo in rule['iconSet']['cfvo']:
tag(doc, 'cfvo', cfvo)
end_tag(doc, 'iconSet')
end_tag(doc, 'cfRule')
end_tag(doc, 'conditionalFormatting')else:
tag(doc, 'color', {'theme': str(color.index).split(':')[1]})
else:
tag(doc, 'color', {'rgb': str(color.index)})
end_tag(doc, 'colorScale')
if 'iconSet' in rule:
iconAttr = {}
for icon_attr in ConditionalFormatting.icon_attributes:
if icon_attr in rule['iconSet']:
iconAttr[icon_attr] = rule['iconSet'][icon_attr]
start_tag(doc, 'iconSet', iconAttr)
for cfvo in rule['iconSet']['cfvo']:
tag(doc, 'cfvo', cfvo)
end_tag(doc, 'iconSet')
end_tag(doc, 'cfRule')
end_tag(doc, 'conditionalFormatting')tag(doc, 'color', {'theme': str(color.index).split(':')[1],
'tint': str(color.index).split(':')[2]})
else:
tag(doc, 'color', {'theme': str(color.index).split(':')[1]})
else:
tag(doc, 'color', {'rgb': str(color.index)})
end_tag(doc, 'colorScale')
if 'iconSet' in rule:
iconAttr = {}
for icon_attr in ConditionalFormatting.icon_attributes:
if icon_attr in rule['iconSet']:
iconAttr[icon_attr] = rule['iconSet'][icon_attr]
start_tag(doc, 'iconSet', iconAttr)
for cfvo in rule['iconSet']['cfvo']:
tag(doc, 'cfvo', cfvo)
end_tag(doc, 'iconSet')
end_tag(doc, 'cfRule')
end_tag(doc, 'conditionalFormatting')tag(doc, 'f', attr=attr, body='%s' % value[1:])
else:
tag(doc, 'f', body='%s' % value[1:])
tag(doc, 'v')
elif cell.data_type == cell.TYPE_NUMERIC:
if isinstance(value, (long, decimal.Decimal)):
func = str
else:
func = repr
tag(doc, 'v', body=func(value))
elif cell.data_type == cell.TYPE_BOOL:
tag(doc, 'v', body='%d' % value)
else:
tag(doc, 'v', body='%s' % value)
end_tag(doc, 'c')
end_tag(doc, 'row')
end_tag(doc, 'sheetData')else:
tag(doc, 'f', body='%s' % value[1:])
tag(doc, 'v')
elif cell.data_type == cell.TYPE_NUMERIC:
if isinstance(value, (long, decimal.Decimal)):
func = str
else:
func = repr
tag(doc, 'v', body=func(value))
elif cell.data_type == cell.TYPE_BOOL:
tag(doc, 'v', body='%d' % value)
else:
tag(doc, 'v', body='%s' % value)
end_tag(doc, 'c')
end_tag(doc, 'row')
end_tag(doc, 'sheetData')if column > 1:
pane = 'bottomRight'
paneAttrs.update(dict(topLeftCell=topLeftCell,
activePane=pane,
state='frozen'))
tag(doc, 'pane', paneAttrs)
selectionAttrs['pane'] = pane
if row > 1 and column > 1:
tag(doc, 'selection', {'pane': 'topRight'})
tag(doc, 'selection', {'pane': 'bottomLeft'})
selectionAttrs.update({'activeCell': worksheet.active_cell,
'sqref': worksheet.selected_cell})
tag(doc, 'selection', selectionAttrs)
end_tag(doc, 'sheetView')
end_tag(doc, 'sheetViews')def write_worksheet_autofilter(doc, worksheet):
auto_filter = worksheet.auto_filter
if auto_filter.filter_columns or auto_filter.sort_conditions:
start_tag(doc, 'autoFilter', {'ref': auto_filter.ref})
for col_id, filter_column in sorted(auto_filter.filter_columns.items()):
start_tag(doc, 'filterColumn', {'colId': str(col_id)})
if filter_column.blank:
start_tag(doc, 'filters', {'blank': '1'})
else:
start_tag(doc, 'filters')
for val in filter_column.vals:
tag(doc, 'filter', {'val': val})
end_tag(doc, 'filters')
end_tag(doc, 'filterColumn')
if auto_filter.sort_conditions:
start_tag(doc, 'sortState', {'ref': auto_filter.ref})
for sort_condition in auto_filter.sort_conditions:
sort_attr = {'ref': sort_condition.ref}
if sort_condition.descending:
sort_attr['descending'] = '1'
tag(doc, 'sortCondtion', sort_attr)
end_tag(doc, 'sortState')
end_tag(doc, 'autoFilter')
elif auto_filter.ref:
tag(doc, 'autoFilter', {'ref': auto_filter.ref})if filter_column.blank:
start_tag(doc, 'filters', {'blank': '1'})
else:
start_tag(doc, 'filters')
for val in filter_column.vals:
tag(doc, 'filter', {'val': val})
end_tag(doc, 'filters')
end_tag(doc, 'filterColumn')
if auto_filter.sort_conditions:
start_tag(doc, 'sortState', {'ref': auto_filter.ref})
for sort_condition in auto_filter.sort_conditions:
sort_attr = {'ref': sort_condition.ref}
if sort_condition.descending:
sort_attr['descending'] = '1'
tag(doc, 'sortCondtion', sort_attr)
end_tag(doc, 'sortState')
end_tag(doc, 'autoFilter')
elif auto_filter.ref:
tag(doc, 'autoFilter', {'ref': auto_filter.ref})def write_worksheet_autofilter(doc, worksheet):
auto_filter = worksheet.auto_filter
if auto_filter.filter_columns or auto_filter.sort_conditions:
start_tag(doc, 'autoFilter', {'ref': auto_filter.ref})
for col_id, filter_column in sorted(auto_filter.filter_columns.items()):
start_tag(doc, 'filterColumn', {'colId': str(col_id)})
if filter_column.blank:
start_tag(doc, 'filters', {'blank': '1'})
else:
start_tag(doc, 'filters')
for val in filter_column.vals:
tag(doc, 'filter', {'val': val})
end_tag(doc, 'filters')
end_tag(doc, 'filterColumn')
if auto_filter.sort_conditions:
start_tag(doc, 'sortState', {'ref': auto_filter.ref})
for sort_condition in auto_filter.sort_conditions:
sort_attr = {'ref': sort_condition.ref}
if sort_condition.descending:
sort_attr['descending'] = '1'
tag(doc, 'sortCondtion', sort_attr)
end_tag(doc, 'sortState')
end_tag(doc, 'autoFilter')
elif auto_filter.ref:
tag(doc, 'autoFilter', {'ref': auto_filter.ref})openpyxl
A Python library to read/write Excel 2010 xlsx/xlsm files
MIT
Latest version published 29 days agoPackage Health Score
75 / 100Popular openpyxl functions
- openpyxl.cell.column_index_from_string
- openpyxl.cell.coordinate_from_string
- openpyxl.cell.get_column_letter
- openpyxl.load_workbook
- openpyxl.reader.excel.load_workbook
- openpyxl.shared.xmltools.QName
- openpyxl.shared.xmltools.SubElement
- openpyxl.styles.Alignment
- openpyxl.styles.Border
- openpyxl.styles.Font
- openpyxl.styles.PatternFill
- openpyxl.styles.Side
- openpyxl.utils.cell.get_column_letter
- openpyxl.utils.get_column_letter
- openpyxl.Workbook
- openpyxl.workbook.Workbook
- openpyxl.xml.functions.end_tag
- openpyxl.xml.functions.start_tag
- openpyxl.xml.functions.SubElement
- openpyxl.xml.functions.tag