Images dissapear in excel documents when copying them with python

Question

import openpyxl

def factuur():
    wb = openpyxl.load_workbook('factuurvoorbeeld1.xlsx')
    Blad1 = wb.active
    Blad1['K7'] = 'logo.png'
    Blad1['E22'] = factuurNr.get()
    Blad1['E23'] = datum.get()
    Blad1['E24'] = debNr.get()
    Blad1['E25'] = locatie.get()
    wb.save('{}.xlsx'.format(factuurNr.get() + ',' + debNr.get()))

I'm trying to program an application that automatically fills in Excel documents by using a simple GUI and entry fields. The problem is, everytime python makes a copy of the base Excel file (The one with personal information that is in every document along with one image), the image dissappears. Do any of you guys know what to do about this? I'm using Python 3.5.

Things I have tried: 1) multiple Excel modules 2) Something about writing code in excel(Not sure if I did this correctly though)

Sorry for my horrible description, I'm don't really know how to describe this kind of stuff. If you want to know more, just leave a question in the comments, I will check as often as i can.

Blad1 = The first sheet of the excel document.

Answer 1

I face same issue with openpyxl 2.6.2

Logo images was added in template excel file but disappear in exported .xlsx file

I just install Pillow and now its exporting all images fine.

pip install Pillow

This is my sample code to create salary slip from template excel file:

from openpyxl import load_workbook


def create_salary_slip():
    wb = load_workbook(filename = 'salary.xlsx')
    # grab the active worksheet
    ws = wb.active
    # Add Income
    ws['D11'] = 25000
    # Add deduction
    ws['M11'] = 1500
    # Save the file
    wb.save("sample.xlsx")

create_salary_slip()

Answer 2

I had the same issue and tried a lot of libs. For me editpyxl does exactly what I need in that scenario:

import editpyxl

wb = editpyxl.Workbook()  
source_filename = r'Template.xlsx'
destination_filename = 'Output.xlsx'

wb.open(source_filename)
ws = wb.active
ws.cell('A1').value = 3.14
wb.save(destination_filename)
wb.close()