xlutils.copy changing celll colors

100 views
Skip to first unread message

Daler Boboev

unread,
Jul 19, 2019, 4:53:26 AM7/19/19
to python-excel
Hi, friends.

I'm trying to edit .xls file with xlutils and i have some issue that i can't handle.

With this code:

from xlrd import open_workbook
from xlutils.copy import copy

wb
= open_workbook(file, formatting_info=True, on_demand=True)
wb_wt = copy(wb)

# do some things with cells

wb_wt
.save(new_file_name)

i'm getting this result:

source file with formatting

Screenshot_123.jpg


output file with formatting

Screenshot_124.jpg


how can i fix this?

P.S. I'm not editing this cells with script.
Reply all
Reply to author
Forward
0 new messages