title: Editing workbooks with rich text in openpyxl
body: <p>I was wondering if openpyxl can read and/or write rich text into excel. I am aware that this question was asked once before in 2012 linked below, but I am not sure if this has changed.</p>
  
  <p>As it stands load_workbook() seems to throw away rich text formatting.</p>
  
  <p>As for a specific problem, I need to open, edit, and save a workbook where some cells have both superscripted and normal text in one cell. When I save the workbook, the format of the first character of the cell is applied to the rest of the cell.</p>
  
  <p>Here is the to 2012 question: <br>
  <a href="https://stackoverflow.com/questions/12371787/how-do-i-find-the-formatting-for-a-subset-of-text-in-an-excel-document-cell">How do I find the formatting for a subset of text in an Excel document cell</a></p>
  
  <p>After looking around, it seems like rich text was implemented in openpyxl (based on the issues list on openpyxl's bitbucket): <br>
  <a href="https://bitbucket.org/openpyxl/openpyxl/issues?q=rich+text" rel="noreferrer">https://bitbucket.org/openpyxl/openpyxl/issues?q=rich+text</a></p>
  
  <p>But I am still unclear on how to use it (if I interpreted the issues list correctly at all). If it helps at all, I am actually not editing the contents of these cells simply that they don't lose formatting on save.</p>
  
  <p>Any thoughts would be greatly appreciated.</p>
  
  <p>Thanks!
  Best</p>