title: Specify range as only selecting filled cells/ending at empty cell Python
body: <p>Is there a way, using win32com, to specify that Python only selects/copies/pastes/autofills/etc a range that stops when it reaches an empty cell?</p>
  
  <p>i.e.
  Range(A1:A%End)</p>
  
  <p>Certainly open to xlrd library suggestions, but my entire script is already using win32com. Thanks for any tips folks!</p>
  
  <pre><code>import win32com.client as win32
  excel = win32.gencache.EnsureDispatch('Excel.Application')
  
  source = excel.Workbooks.Open("C:\source")
  excel.Range("A:AA").Select()
  excel.Selection.Copy()
  
  copy = excel.Workbooks.Open("C:\copy")
  excel.Range("E:AE").Select()
  excel.Selection.PasteSpecial()
  </code></pre>