title: xlwings function to find the last row with data
body: <p>I am trying to find the last row in a column with data. to replace the vba function: <code>LastRow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row</code></p>
  
  <p>I am trying this, but this pulls in all rows in Excel. How can I just get the last row.</p>
  
  <pre><code>from xlwings import Workbook, Range
  wb = Workbook()
  print len(Range('A:A'))
  </code></pre>