Openpyxl , how to preserve .xlsx file style which was before , after saving it with openpyxl .save() function?

Question

I have an issue with openpyxl library.

Problem:

When I used xlwt, opened an .xls file, and wrote some cells in there, the styles of cells I didn't touch remained the same. But now I have to work with xlsx documents, so I chose openpyxl for this. But after saving it with a .save function, it completely strips the style of a document, even the cells I didn't touch at all.

Any suggestions on how I can preserve the style?

This hasn't been an issue in openpyxl since version 2. – Charlie Clark Sep 11 '15 at 07:30 — Charlie Clark, Sep 11 '15 at 07:30
I see the same problem with latest openpyxl v 2.3.2 – Peteris Dec 28 '15 at 13:11 — Peteris, Dec 28 '15 at 13:11

score 3 · Answer 1 · edited May 23 '17 at 12:24

3

I'm having this exact problem, apparently there is no good way to preserve the styles in openpyxl, see Use openpyxl to edit a Excel2007 file (.xlsx) without changing its own styles?

edited May 23 '17 at 12:24

Community

1
1

answered Oct 26 '12 at 18:45

A Alstone

947
2
9
12

score 1 · Answer 2 · answered Feb 25 '19 at 01:59

1

I don't think openpyxl solved this issue yet. You can try pywin32 to directly interact with windows API with Excel, you can do everything there you want.

answered Feb 25 '19 at 01:59

Haohan Li

51
3

Openpyxl , how to preserve .xlsx file style which was before , after saving it with openpyxl .save() function?

2 Answers2