title: Save Pandas DataFrames with formulas to xlsx files
body: <p>In a Pandas DataFrame i have some "cells" with values and some that need to contain excel formulas. I have read that i can get formulas with</p>
  
  <pre><code>link = 'HYPERLINK("#Groups!A' + str(someInt) + '"; "LINKTEXT")'
  xlwt.Formula(link)
  </code></pre>
  
  <p>and store them in the dataframe.</p>
  
  <p>When i try to save my dataframe as an xlsx file with</p>
  
  <pre><code>writer = pd.ExcelWriter("pandas" + str(fileCounter) + ".xlsx", engine = "xlsxwriter")
  df.to_excel(writer, sheet_name = "Paths", index = False)
  # insert more sheets here
  writer.save()
  </code></pre>
  
  <p>i get the error:</p>
  
  <pre><code>TypeError: Unsupported type &lt;class 'xlwt.ExcelFormula.Formula'&gt; in write()
  </code></pre>
  
  <p>So i tried to write my formula as a string to my dataframe but Excel wants to restore the file content and then fills all formula cells with <code>0</code>'s.</p>
  
  <p><strong>Edit:</strong> I managed to get it work with regular strings but nevertheless would be interested in a solution for xlwt formulas.</p>
  
  <p>So my question is: How do i save dataframes with formulas to xlsx files?</p>