Openpyxl doesn't support multiple font-sizes or styles for a single cell
So I'm working with an existing workbook and trying to populate some data for it. The workbook is available publicly here. It can also be accessed by clicking the 2021 Real Estate Asset Spreadsheet (Excel format)
button on this page. In case the file is taken down (as it is a yearly spreadsheet) I've uploaded a copy to my personal OneDrive here.
In the workbook there are some cells which have multiple font-sizes in use, see 'Energy' E-J4, and some have multiple font-styles, see 'Reporting Characteristics' H5 and I5. When the workbook is loaded and then saved, the formatting is lost and a single size and style is applied to the cell.
It's a pretty minor issue but thought it's worth logging :)
Edited by Dylan Morroll