title: How to paste values only in Excel using Python and openpyxl
body: <p>I have an Excel worksheet.
  In column J i have some some source data which i used to make calculations in column K.
  Column K has the values I need, but when i click on a cell the formula shows up.
  I only want the values from column K, not the formula.
  I read somewhere that i need to set data only=True, which I have done.
  I then pasted data from Column K to Column L(with the intention of later deleting Columns J and K).
  I thought that Column L will have only the values from K but if i click on a cell, the formula still shows up.
  How do I simply paste values only from one column to another?</p>
  <pre><code>import openpyxl
  wb = openpyxl.load_workbook('edited4.xlsx', data_only=True)
  sheet = wb['Sheet1']
  
  last_row = 100  
  for i in range(2, last_row):
      cell = &quot;K&quot; + str(i)
      a_cell = &quot;J&quot; + str(i)
      sheet[cell] = '=IF(' + a_cell + '=&quot;R&quot;,&quot;Yes&quot;,&quot;No&quot;)'
  
  rangeselected = []
  for i in range (1, 100,1):
      rangeselected.append(sheet.cell(row = i, column = 11).value)
  for i in range (1, 1000,1):
     sheet.cell(row=i, column=12).value = rangeselected[i-1]
  
  wb.save('edited4.xlsx')
  </code></pre>