How to format text as subscript in openpyxl

Question

I need to output some text into excel format with openpyxl. I want some of my texts as subscripts and others as superscripts.

I have checked the documentation for openpyxl but can't find anything about that. I did find the openpyxl.cell.text module here.

This code runs fine

wb = OP.Workbook()
ws = wb.active

c = OP.cell.text.InlineFont(vertAlign='subscript')
ws.cell(row=1, column=1, value='ab')

wb.save('example.xlsx')

But I don't know how I can use c to make text appear as subscript.

Possible duplicate of [Editing workbooks with rich text in openpyxl](http://stackoverflow.com/questions/28774757/editing-workbooks-with-rich-text-in-openpyxl) — Charlie Clark, Apr 12 '17 at 08:15

score 0 · Answer 1 · answered Jun 15 '17 at 08:10

Make sure you import the right modules.

This one works:

from openpyxl import Workbook
from openpyxl.styles import PatternFill, Border, Side, Alignment, Protection, Font
wb = Workbook()
ws = wb.active
a = ws['A1']
ws['A1'] =  'appel'
a.font = Font(bold=True, vertAlign='subscript')
wb.save('test.xlsx')

How to format text as subscript in openpyxl

1 Answers1