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)