Python MergeCells Examples

Example #1

def write_mergecells(ws):
    """Write merged cells to xml."""

    merged = [MergeCell(str(ref)) for ref in ws.merged_cells]

    if merged:
        return MergeCells(mergeCell=merged).to_tree()

Example #2

def write_mergecells(worksheet):
    """Write merged cells to xml."""

    merged = [MergeCell(ref) for ref in worksheet._merged_cells]

    if merged:
        return MergeCells(mergeCell=merged).to_tree()

Example #3

 def parse_merge(self, element):
     merged = MergeCells.from_tree(element)
     self.ws.merged_cells.ranges = merged.mergeCell

Example #4

File: worksheet.py Project: KFGroup/titan-master4

 def parse_merge(self, element):
     merged = MergeCells.from_tree(element)
     self.ws.merged_cells.ranges = merged.mergeCell
     for cr in merged.mergeCell:
         self.ws._clean_merge_range(cr)

Example #5

File: worksheet.py Project: AksanBA/ExcelProcessing

 def parse_merge(self, element):
     merged = MergeCells.from_tree(element)
     for c in merged.mergeCell:
         self.ws.merge_cells(c.ref)

Example #6

File: worksheet.py Project: cloudera/hue

 def parse_merge(self, element):
     merged = MergeCells.from_tree(element)
     for c in merged.mergeCell:
         self.ws.merge_cells(c.ref)

Example #7

File: worksheet.py Project: JLL-Benson/CHN_DQ

 def parse_merge(self, element):
     merged = MergeCells.from_tree(element)
     self.ws.merged_cells.ranges = merged.mergeCell
     for cr in merged.mergeCell:
         self.ws._clean_merge_range(cr)