def write_pagebreaks(worksheet):
breaks = worksheet.page_breaks
if breaks:
tag = Element( 'rowBreaks', {'count': str(len(breaks)),
'manualBreakCount': str(len(breaks))})
for b in breaks:
tag.append(Element('brk', id=str(b), man=true, max='16383',
min='0'))
return tag
def write_hyperlinks(worksheet):
"""Write worksheet hyperlinks to xml."""
tag = Element('hyperlinks')
for cell in worksheet.get_cell_collection():
if cell.hyperlink_rel_id is not None:
attrs = {'display': cell.hyperlink,
'ref': cell.coordinate,
'{%s}id' % REL_NS: cell.hyperlink_rel_id}
tag.append(Element('hyperlink', attrs))
if tag.getchildren():
return tag
