title: How to paste special in excel with python
body: <p>So I am trying to copy alot of data from one woorkbook to another.  The thing is that the data in the source workbook has some weird formating so I want to just get the values.  The code I have so far is this.</p>
  
  <pre><code>excel=win32com.client.Dispatch("Excel.Application");
  excel.Visible = 1;
  source = excel.Workbooks.Open(Cali.xlsm');
  copy = excel.Workbooks.Open(temp.xlsx');
  sdata = source.ActiveSheet;cdata = copy.ActiveSheet;
  data=sdata.Range("89:89")
  sdata.Range("89:89",data.End(4)).Copy()
  </code></pre>
  
  <p>now I can use </p>
  
  <pre><code>cdata.Paste()
  </code></pre>
  
  <p>but it pastes the formating as well</p>
  
  <p>I found </p>
  
  <pre><code>cdata.PasteSpecial()
  </code></pre>
  
  <p>but it also pastes the formating.</p>
  
  <p>Anyone who know how to use PasteSpecial() so it copies just the values or someone knows a better way I would be very apprecitave.</p>