Writing XLSX: Image is not inserted and excel complains about drawing issue on open

[G. Wiora]

After switching from v2.5.9 to 2.5.10 my code for generating an excel file with a drawing added is not working any more as expected. The file created makes excel issuing a warning about a "corrupted file". Excel offers to repair the file and successfully opens it after repair but the png image imported is not visible. Looking into the xlsx files with a zip tool I found the png image is correctly placed in the excel file but in difference to 2.5.9 the file "./xl/drawings/drawing1.xml" is not filled correctly as with 2.5.9. Please see the attached files generated with 2.5.9 and 2.5.10 version.

I just verified the odd behaviour with 2.5.11 too.

The following code snippet shows how I am adding the image.

img = Image(logofile)
self.wb.active.add_image(img,addr)

[CharlieC]

Thanks for the report and the sample files. 2.5.10 does contain a slight change on the way anchors are handled for better processing of some existing files but it shouldn't have changed existing behaviour.

[CharlieC]

Must bind the picture frame to the anchor when adding a new image. Resolves #1133 but test required.

→ <<cset 3977977a46e6>>

[G. Wiora]

I inserted the new code in 2.5.11 and it worked.

Excellent, thank you!

EDIT: Bug is fixed in 2.5.12

[CharlieC]

Issue #1137 was marked as a duplicate of this issue.

[timk]

I'm getting this problem with 2.5.11. I'm running the sample code:

wb = Workbook()
    ws = wb.active
    ws['A1'] = 'You should see three logos below'

     # create an image
    img = Image('logo.png')

     # add to worksheet and anchor next to cells
    ws.add_image(img, 'A1')
    wb.save('logo.xlsx')

The Excel recovery report isn't very helpful:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error119160_05.xml</logFileName><summary>Errors were detected in file 'C:\code\StatsReporter\stats_reporter\logo.xlsx'</summary><repairedRecords><repairedRecord>Repaired Records: Drawing from /xl/drawings/drawing1.xml part (Drawing shape)</repairedRecord></repairedRecords></recoveryLog>

[CharlieC]

@timk you'll actually need to 2.5.12 for this. Always worth checking the release notes.