[Answered ]-Python, openpyxl: how to preserve formating in the cell?

by

2👍

If I open the xml in xlsx file I see the tag vertAlign val=”superscript”

Comments: I have to use Python 2 and openpyxl 2.2. And the cell value is not just ‘2’ or ‘3’ it is ‘m^2’ or ‘m^3’ or what ever,

This is Character Format, you can’t pass Character Format to Django.
Only the value which ist ^2 or ^3.

For instance this would help:

import re
if vertAlign == superscript:
    value = re.sub('\^2', '²', cell.value)
    value = re.sub('\^3', '³', value)

This changes all simulated superscipt(2|3), to unicode(²|³).

Tested with Python:3.4.2 – openpyxl:2.4.1 – LibreOffice: 4.3.3.2
Should also work with your Python 2 and openpyxl 2.2.

👤stovfl

Leave a comment