title: figuring out end of row in a worksheet
body: <p>I use EPPlus to read a worksheet. In this worksheet, the data I need is in columns <code>B-D</code>. In column <code>A</code> there are static values, that I would ignore. The values in col <code>A</code> are filled in till <code>Row 1000</code>. But, the data I need will be there only till, say for example <code>Row 450</code>. Currently I use           </p>
  
  <pre><code>int endRow = workSheet.Dimension.End.Row;
  </code></pre>
  
  <p>to calculate the last row to read, but that returns me a value of <code>1000</code>. Is there a way for me to get the value of endRow to be <code>450</code>, ignoring col <code>A</code>?</p>