I have an excel (xlsx) file and I am trying to read the style of the template, in order to copy the style to another excel file, using python xlrd, and xlwt library
how can I read the style from a cell?
Asked
Active
Viewed 1,759 times
1 Answers
0
You can use xlutils.copy in order to be able to copy the style from one sheet to other one.
This question seems to be duplicated. Following Preserving styles using python's xlrd,xlwt, and xlutils.copy
Community
- 1
- 1
Nima Soroush
- 12,242
- 4
- 52
- 53
-
this is problematic since I am the template file is xls. but I have an xlsx. – Barak Rosenfeld Nov 10 '14 at 09:44
-
How about trying openpyxl (https://openpyxl.readthedocs.org/en/latest/) It provides 'Copying styles' tool too. This is what you need (https://openpyxl.readthedocs.org/en/latest/styles.html#copying-styles) – Nima Soroush Nov 10 '14 at 10:43
-
and if you are persisting to use `xlrd`, you need to upgrade `xlrd` version to `0.8.0`. use `pip install xlrd --upgrade` – Nima Soroush Nov 10 '14 at 11:03
-
what is is the change in the upgrade of the 0.8 version? – Barak Rosenfeld Nov 10 '14 at 13:02
-
It supports `xlsx` files. You can visit the home page for more specific detail (http://www.python-excel.org/) – Nima Soroush Nov 10 '14 at 13:56