def test_ctor(self, WorksheetCopy):
wb = Workbook()
ws1 = wb.create_sheet()
ws2 = wb.create_sheet()
copier = WorksheetCopy(ws1, ws2)
assert copier.source == ws1
assert copier.target == ws2
def test_write_hyperlink_image_rels(Workbook, Image, datadir):
datadir.chdir()
wb = Workbook()
ws = wb.create_sheet()
ws['A1'].value = "test"
ws['A1'].hyperlink = "http://test.com/"
i = Image("plain.png")
ws.add_image(i)
raise ValueError("Resulting file is invalid")
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/>
<workbookProtection/>
<bookViews>
<workbookView activeTab="1" autoFilterDateGrouping="1" firstSheet="0" minimized="0" showHorizontalScroll="1" showSheetTabs="1" showVerticalScroll="1" tabRatio="600" visibility="visible"/>
</bookViews>
<sheets>
<sheet name="Sheet" sheetId="1" state="hidden" r:id="rId1"/>
<sheet name="Sheet1" sheetId="2" state="visible" r:id="rId2"/>
</sheets>
<definedNames/>
<calcPr calcId="124519" fullCalcOnLoad="1"/>
</workbook>
"""
diff = compare_xml(xml, expected)
assert diff is None, diff
def copier(WorksheetCopy):
wb = Workbook()
ws1 = wb.active
ws2 = wb.create_sheet('copy_sheet')
return WorksheetCopy(ws1, ws2)
