0

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.

Community
  • 1
  • 1
Valeriy Gaydar
  • 500
  • 1
  • 6
  • 26
  • 3
    Not sure this is duplicate, but it's definitely related and could be helpful: http://stackoverflow.com/questions/3723793/preserving-styles-using-pythons-xlrd-xlwt-and-xlutils-copy – John Y Oct 23 '14 at 15:27

1 Answers1

0

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

Valeriy Gaydar
  • 500
  • 1
  • 6
  • 26