title: is it possible to insert a excel formula value not formula
body: <p>i am trying to insert a value using excel formula which is happening successfully but i want to save the value not formula ,here is the piece of code i am trying so far.</p>
  
  <pre><code>print("Adding formula to " + filename)         
  
  
  for i,cellObj in enumerate(sheet_formula['P'],1):
          cellObj.value='=IF(AND(OR(A{0}="g_m",A{0}="s_m"),ISNUMBER(SEARCH("A", E{0}))), "A", VLOOKUP(A{0},\'i ma\'!A:B, 2, FALSE))'.format(i)
          sheet_formula.cell(row=1, column=16).value = 'C'
  </code></pre>
  
  <p>this piece of is able to insert formula but i want to save the value not formula</p>