def test_write_anchor_onecell(self): from legacy_openpyxl.drawing import Image path = os.path.join(DATADIR, "plain.png") drawing = Image(path).drawing drawing.anchortype = "oneCell" drawing.anchorcol = 0 drawing.anchorrow = 0 root = Element("test") self.dw._write_anchor(root, drawing) xml = get_xml(root) expected = """<test><xdr:oneCellAnchor xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"><xdr:from><xdr:col>0</xdr:col><xdr:colOff>0</xdr:colOff><xdr:row>0</xdr:row><xdr:rowOff>0</xdr:rowOff></xdr:from><xdr:ext cx="1123950" cy="1123950"/></xdr:oneCellAnchor></test>""" diff = compare_xml(xml, expected) assert diff is None, diff
def test_write_hyperlink_image_rels(Workbook, Image): wb = Workbook() ws = wb.create_sheet() ws.cell('A1').value = "test" ws.cell('A1').hyperlink = "http://test.com/" img = os.path.join(DATADIR, "plain.png") i = Image(img) ws.add_image(i) raise ValueError("Resulting file is invalid")
def test_ctor(self): Image = self.make_one() i = Image(img=self.img) assert i.nochangearrowheads == True assert i.nochangeaspect == True d = i.drawing assert d.coordinates == ((0, 0), (1, 1)) assert d.width == 118 assert d.height == 118
def test_write_anchor(self): from legacy_openpyxl.drawing import Image path = os.path.join(DATADIR, "plain.png") drawing = Image(path).drawing root = Element("test") self.dw._write_anchor(root, drawing) xml = get_xml(root) expected = """<test><xdr:absoluteAnchor xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"><xdr:pos x="0" y="0"/><xdr:ext cx="1123950" cy="1123950"/></xdr:absoluteAnchor></test>""" diff = compare_xml(xml, expected) assert diff is None, diff
def test_write_images(self): from legacy_openpyxl.drawing import Image path = os.path.join(DATADIR, "plain.png") img = Image(path) root = Element("{%s}wsDr" % SHEET_DRAWING_NS) self.dw._write_image(root, img, 1) drawing_schema.assertValid(root) xml = get_xml(root) expected = """<xdr:wsDr xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"> <xdr:absoluteAnchor> <xdr:pos x="0" y="0"/> <xdr:ext cx="1123950" cy="1123950"/> <xdr:pic> <xdr:nvPicPr> <xdr:cNvPr id="2" name="Picture 1"/> <xdr:cNvPicPr> <a:picLocks noChangeArrowheads="1" noChangeAspect="1"/> </xdr:cNvPicPr> </xdr:nvPicPr> <xdr:blipFill> <a:blip xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" cstate="print" r:embed="rId1"/> <a:srcRect/> <a:stretch> <a:fillRect/> </a:stretch> </xdr:blipFill> <xdr:spPr bwMode="auto"> <a:xfrm> <a:off x="0" y="0"/> <a:ext cx="0" cy="0"/> </a:xfrm> <a:prstGeom prst="rect"> <a:avLst/> </a:prstGeom> <a:noFill/> <a:ln w="1"> <a:noFill/> <a:miter lim="800000"/> <a:headEnd/> <a:tailEnd len="med" type="none" w="med"/> </a:ln> <a:effectLst/> </xdr:spPr> </xdr:pic> <xdr:clientData/> </xdr:absoluteAnchor> </xdr:wsDr> """ diff = compare_xml(xml, expected) assert diff is None, diff
def test_write_images(): wb = Workbook() ew = ExcelWriter(workbook=wb) from legacy_openpyxl.drawing import Image imagepath = os.path.join(DATADIR, "plain.png") img = Image(imagepath) buf = BytesIO() archive = zipfile.ZipFile(buf, 'w') ew._write_images([img], archive, 1) archive.close() buf.seek(0) archive = zipfile.ZipFile(buf, 'r') zipinfo = archive.infolist() assert len(zipinfo) == 1 assert zipinfo[0].filename == 'xl/media/image1.png'
import os from legacy_openpyxl import Workbook from legacy_openpyxl.drawing import Image from legacy_openpyxl.tests.helper import DATADIR wb = Workbook() ws = wb.get_active_sheet() ws.cell('A1').value = 'You should see a logo below' # create an image instance pth = os.path.split(__file__)[0] img = Image(os.path.join(DATADIR, 'plain.png')) # place it if required img.drawing.left = 200 img.drawing.top = 100 # you could also 'anchor' the image to a specific cell # img.anchor(ws.cell('B12')) # add to worksheet ws.add_image(img) wb.save(os.path.join(pth, 'files', 'logo.xlsx'))
def test_anchor_onecell(self): Image = self.make_one() i = Image(self.img) c = DummyCell() vals = i.anchor(c, anchortype="oneCell") assert vals == ((0, 0), None)
def test_anchor(self): Image = self.make_one() i = Image(self.img) c = DummyCell() vals = i.anchor(c) assert vals == (('A', 1), (118, 118))
def test_import(self): Image = self.make_one() with pytest.raises(ImportError): i = Image._import_image(self.img)