/usr/lib/python3/dist-packages/openpyxl/writer/lxml_worksheet.py is in python3-openpyxl 2.3.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | from __future__ import absolute_import
# Copyright (c) 2010-2015 openpyxl
from operator import itemgetter
from openpyxl.compat import safe_string
from .etree_worksheet import get_rows_to_write
from openpyxl.xml.functions import xmlfile
### LXML optimisation using xf.element to reduce instance creation
def write_rows(xf, worksheet):
"""Write worksheet data to xml."""
all_rows = get_rows_to_write(worksheet)
dims = worksheet.row_dimensions
max_column = worksheet.max_column
with xf.element("sheetData"):
for row_idx, row in sorted(all_rows):
attrs = {'r': '%d' % row_idx, 'spans': '1:%d' % max_column}
if row_idx in dims:
row_dimension = dims[row_idx]
attrs.update(dict(row_dimension))
with xf.element("row", attrs):
for col, cell in sorted(row, key=itemgetter(0)):
if cell.value is None and not cell.has_style:
continue
write_cell(xf, worksheet, cell, cell.has_style)
def write_cell(xf, worksheet, cell, styled=False):
coordinate = cell.coordinate
attributes = {'r': coordinate}
if styled:
attributes['s'] = '%d' % cell.style_id
if cell.data_type != 'f':
attributes['t'] = cell.data_type
value = cell._value
if value == '' or value is None:
with xf.element("c", attributes):
return
with xf.element('c', attributes):
if cell.data_type == 'f':
shared_formula = worksheet.formula_attributes.get(coordinate, {})
with xf.element('f', shared_formula):
if value is not None:
xf.write(value[1:])
value = None
if cell.data_type == 's':
value = worksheet.parent.shared_strings.add(value)
with xf.element("v"):
if value is not None:
xf.write(safe_string(value))
|