Resetting chart style from premade template when modifying in program

[Adriantega12]

Hello everyone! Really happy about something like QXlsx existing but it seems to have an issue when modifying an existing file.

I have this template I made so I can modify it when needed and save it as a new file, but it seems that when loading it, QXlsx resets the style on my premade charts. (The template exists in first place so I can just insert data using code and the user can visualize the info dump later in the xlsx)

Is there a way around this or a fix coming? Is there a way I can contribute to help fixing this? (As it is in my best interest)

Template: Modified:

Thanks in advance!

[VSRonin]

This happens because this library will actually re-create the file from scratch and anything that is not supported will be lost.

As a workaround you could open your previous file as a zip archive, save the contents of xl\charts\, edit the file using qxlsx, reopen the file as a zip and overwrite those files. Having said that, this workaround only works for very simple charts, anything a bit involved might fail

[Adriantega12]

@VSRonin Great! I'll try that and get back to you.