The worksheet I am working on is xlsx 2007-365 format (created by LibreOffice)
Please provide a sample file and code. NB. copy_worksheet is by necessity limited.
The issue is more intricate:
Even though the original sheet is not modified, "almost all" color from every sheet is removed.
Attaching before, and after version
Code cannot get any simpler:
wb = load_workbook('Sanitized-2-Orig.xlsx')
for i in range(1, 31):
target = wb.copy_worksheet(wb['Pattern'])
target.title = '%02d.09' % i