def _write_print_settings(self, root):
settings = SubElement(root, '{%s}printSettings' % CHART_NS)
SubElement(settings, '{%s}headerFooter' % CHART_NS)
margins = dict([(k, safe_string(v)) for (k, v) in iteritems(self.chart.print_margins)])
SubElement(settings, '{%s}pageMargins' % CHART_NS, margins)
SubElement(settings, '{%s}pageSetup' % CHART_NS)
def _write_print_settings(self):
settings = SubElement(self.root, '{%s}printSettings' % CHART_NS)
SubElement(settings, '{%s}headerFooter' % CHART_NS)
margins = dict([(k, safe_string(v)) for (k, v) in iteritems(self.chart.print_margins)])
SubElement(settings, '{%s}pageMargins' % CHART_NS, margins)
SubElement(settings, '{%s}pageSetup' % CHART_NS)
def setRules(self, cfRules):
"""Set the conditional formatting rules from a dictionary. Intended for use when loading a document.
cfRules use the structure: {range_string: [rule1, rule2]}, eg:
{'A1:A4': [{'type': 'colorScale', 'priority': '13', 'colorScale': {'cfvo': [{'type': 'min'}, {'type': 'max'}],
'color': [Color('FFFF7128'), Color('FFFFEF9C')]}]}
"""
self.cf_rules = {}
self.max_priority = 0
priorityMap = []
for range_string, rules in iteritems(cfRules):
self.cf_rules[range_string] = rules
for rule in rules:
priorityMap.append(int(rule['priority']))
priorityMap.sort()
for range_string, rules in iteritems(cfRules):
self.cf_rules[range_string] = rules
for rule in rules:
priority = priorityMap.index(int(rule['priority'])) + 1
rule['priority'] = str(priority)
if 'priority' in rule and priority > self.max_priority:
self.max_priority = priority
def setRules(self, cfRules):
"""Set the conditional formatting rules from a dictionary. Intended for use when loading a document.
cfRules use the structure: {range_string: [rule1, rule2]}, eg:
{'A1:A4': [{'type': 'colorScale', 'priority': '13', 'colorScale': {'cfvo': [{'type': 'min'}, {'type': 'max'}],
'color': [Color('FFFF7128'), Color('FFFFEF9C')]}]}
"""
self.cf_rules = {}
self.max_priority = 0
priorityMap = []
for range_string, rules in iteritems(cfRules):
self.cf_rules[range_string] = rules
for rule in rules:
priorityMap.append(int(rule['priority']))
priorityMap.sort()
for range_string, rules in iteritems(cfRules):
self.cf_rules[range_string] = rules
for rule in rules:
priority = priorityMap.index(int(rule['priority'])) + 1
rule['priority'] = str(priority)
if 'priority' in rule and priority > self.max_priority:
self.max_priority = priority
def _write_print_settings(self, root):
settings = SubElement(root, '{%s}printSettings' % CHART_NS)
SubElement(settings, '{%s}headerFooter' % CHART_NS)
try:
# Python 2
print_margins_items = iteritems(self.chart.print_margins)
except AttributeError:
# Python 3
print_margins_items = self.chart.print_margins.items()
margins = dict([(k, safe_string(v)) for (k, v) in print_margins_items])
SubElement(settings, '{%s}pageMargins' % CHART_NS, margins)
SubElement(settings, '{%s}pageSetup' % CHART_NS)
def __init__(self, sheet):
self.sheet = sheet
# get list of comments
self.comments = []
for coord, cell in iteritems(sheet._cells):
if cell.comment is not None:
self.comments.append(cell.comment)
# get list of authors
self.authors = []
self.author_to_id = {}
for comment in self.comments:
if comment.author not in self.author_to_id:
self.author_to_id[comment.author] = str(len(self.authors))
self.authors.append(comment.author)
def __init__(self, sheet):
self.sheet = sheet
# get list of comments
self.comments = []
for coord, cell in iteritems(sheet._cells):
if cell.comment is not None:
self.comments.append(cell.comment)
# get list of authors
self.authors = []
self.author_to_id = {}
for comment in self.comments:
if comment.author not in self.author_to_id:
self.author_to_id[comment.author] = str(len(self.authors))
self.authors.append(comment.author)
def update(self, dictionary):
for k, v in iteritems(dictionary):
self[k] = v
def update(self, dictionary):
for k, v in iteritems(dictionary):
self[k] = v