How to extract the superscript or subscript data in excel with python?

I wanna to analysis chemical formula data in excel with python. Beacause excel data already have the format to distinguish charge or atomic number, so I don’t need to interpret it de novo. But I met with some difficulties when I read it with python.

Data like this in pic

pandas, xlrd, openpyxl, even python-docx, none of them could read data with superscript distinguished. It all be deemed as plain text. And it seems that the format of superscript or subscript cannot be directly matched.

How could I do to finish my task without interpreting it de novo? No matter python or any other data processing tools is ok.

%d bloggers like this: