/usr/lib/python3/dist-packages/openpyxl/writer/tests/test_workbook.py is in python3-openpyxl 2.3.0-3.
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 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 | from __future__ import absolute_import
# Copyright (c) 2010-2015 openpyxl
#stdlib
from io import BytesIO
import os
# test
import pytest
from openpyxl.tests.helper import compare_xml
# package
from openpyxl import Workbook, load_workbook
from openpyxl.workbook.names.named_range import NamedRange
from openpyxl.xml.functions import Element, tostring, fromstring
from openpyxl.xml.constants import XLTX, XLSX, XLSM, XLTM
from .. excel import (
save_workbook,
save_virtual_workbook,
)
from .. workbook import (
write_workbook,
write_workbook_rels,
)
def test_write_auto_filter(datadir):
datadir.chdir()
wb = Workbook()
ws = wb.active
ws.cell('F42').value = 'hello'
ws.auto_filter.ref = 'A1:F1'
content = write_workbook(wb)
with open('workbook_auto_filter.xml') as expected:
diff = compare_xml(content, expected.read())
assert diff is None, diff
def test_write_hidden_worksheet():
wb = Workbook()
ws = wb.active
ws.sheet_state = ws.SHEETSTATE_HIDDEN
wb.create_sheet()
xml = write_workbook(wb)
expected = """
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
<workbookPr/>
<bookViews>
<workbookView activeTab="0"/>
</bookViews>
<sheets>
<sheet name="Sheet" sheetId="1" state="hidden" r:id="rId1"/>
<sheet name="Sheet1" sheetId="2" r:id="rId2"/>
</sheets>
<definedNames/>
<calcPr calcId="124519" fullCalcOnLoad="1"/>
</workbook>
"""
diff = compare_xml(xml, expected)
assert diff is None, diff
def test_write_hidden_single_worksheet():
wb = Workbook()
ws = wb.active
ws.sheet_state = ws.SHEETSTATE_HIDDEN
with pytest.raises(ValueError):
write_workbook(wb)
def test_write_empty_workbook(tmpdir):
tmpdir.chdir()
wb = Workbook()
dest_filename = 'empty_book.xlsx'
save_workbook(wb, dest_filename)
assert os.path.isfile(dest_filename)
def test_write_virtual_workbook():
old_wb = Workbook()
saved_wb = save_virtual_workbook(old_wb)
new_wb = load_workbook(BytesIO(saved_wb))
assert new_wb
def test_write_workbook_rels(datadir):
datadir.chdir()
wb = Workbook()
content = write_workbook_rels(wb)
with open('workbook.xml.rels') as expected:
diff = compare_xml(content, expected.read())
assert diff is None, diff
def test_write_workbook(datadir):
datadir.chdir()
wb = Workbook()
content = write_workbook(wb)
with open('workbook.xml') as expected:
diff = compare_xml(content, expected.read())
assert diff is None, diff
def test_write_named_range():
from openpyxl.writer.workbook import _write_defined_names
wb = Workbook()
ws = wb.active
xlrange = NamedRange('test_range', [(ws, "A1:B5")])
wb._named_ranges.append(xlrange)
root = Element("root")
_write_defined_names(wb, root)
xml = tostring(root)
expected = """
<root>
<s:definedName xmlns:s="http://schemas.openxmlformats.org/spreadsheetml/2006/main" name="test_range">'Sheet'!$A$1:$B$5</s:definedName>
</root>
"""
diff = compare_xml(xml, expected)
assert diff is None, diff
@pytest.mark.parametrize('tmpl, code_name', [
('workbook.xml', u'ThisWorkbook'),
('workbook_russian_code_name.xml', u'\u042d\u0442\u0430\u041a\u043d\u0438\u0433\u0430')
])
def test_read_workbook_code_name(datadir, tmpl, code_name):
from openpyxl.reader.workbook import read_workbook_code_name
datadir.chdir()
with open(tmpl, "rb") as expected:
assert read_workbook_code_name(expected.read()) == code_name
def test_write_workbook_code_name():
wb = Workbook()
wb.code_name = u'MyWB'
content = write_workbook(wb)
expected = """
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
<workbookPr codeName="MyWB"/>
<bookViews>
<workbookView activeTab="0"/>
</bookViews>
<sheets>
<sheet name="Sheet" sheetId="1" r:id="rId1"/>
</sheets>
<definedNames/>
<calcPr calcId="124519" fullCalcOnLoad="1"/>
</workbook>
"""
diff = compare_xml(content, expected)
assert diff is None, diff
def test_write_root_rels():
from ..workbook import write_root_rels
wb = Workbook()
xml = write_root_rels(wb)
expected = """
<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">
<Relationship Id="rId1" Target="xl/workbook.xml" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument"/>
<Relationship Id="rId2" Target="docProps/core.xml" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties"/>
<Relationship Id="rId3" Target="docProps/app.xml" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties"/>
</Relationships>
"""
diff = compare_xml(xml, expected)
assert diff is None, diff
|