Python Forum
Openpyxl - When save existing xlsx sheet, images/drawing does not get saved
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Openpyxl - When save existing xlsx sheet, images/drawing does not get saved
#1
Openpyxl - After modifying existing xlsx sheet with some drawings/images, when saved already existing images and drawings does not get saved.

I am new to python, please let me know is this expected behaviour/openpyxl limitation or their some workaround for this.
I have not pasted any code here as it is a general query
Thanks in advance
Reply
#2
as it says in the docs:
Quote:Warning

openpyxl does currently not read all possible items in an Excel file so images and charts will be lost from existing files if they are opened and saved with the same name.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#3
Thanks for the update.
Could you please point out, if their is any other possible way to make this work.
Maybe by using some other packages..
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  openpyxl issue - How to reset sheet.ins_row to the real last row ... ejwjohn 6 773 Nov-08-2023, 01:19 PM
Last Post: ejwjohn
  how to save to multiple locations during save cubangt 1 540 Oct-23-2023, 10:16 PM
Last Post: deanhystad
  openpyxl rename sheet acting strange Pedroski55 1 1,901 Sep-26-2022, 08:56 AM
Last Post: buran
  Using .pb saved model for object detection hobbyist 2 1,169 Aug-03-2022, 05:55 AM
Last Post: hobbyist
  bytes object saved as .mp4 jttolleson 10 5,839 Feb-25-2022, 02:42 PM
Last Post: jttolleson
  Python3 doesn't populate xlsx file with openpyxl Auldyin75 2 2,523 Feb-16-2021, 12:00 PM
Last Post: Auldyin75
  Append excel sheet using openpyxl TammyP 1 2,361 Feb-02-2021, 06:32 PM
Last Post: nilamo
  Why can't numpy array be restored to a saved value? pjfarley3 1 1,708 Nov-25-2020, 07:40 AM
Last Post: pjfarley3
  Writing to existing excel sheet jksvend 0 1,936 Oct-12-2020, 11:19 AM
Last Post: jksvend
  P3, openpyxl, csv to xlsx, cell is not number, problem with colorize genderbee 1 2,129 Sep-29-2020, 03:20 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020