pythonexcelxlrdxlwtxlutils

Python, copy xls file with marking


I need to copy/edit existing sheet of xls file to new file with marking. What i've tried:

import xlrd
from xlutils.copy import copy
workbook = xlrd.open_workbook('template1.xls')
new_wb = copy(workbook)
new_wb.save("test.xls")

But marking is not saved. Existing file is something e.g.: Screenshot of existing xls file

Result after "copy" is: Result of copying

Help me please.


Solution

  • The best answer was in comments. I have reached answer limit, so need to set best answer.