title: How to read the entire worksheet from excel
body: <p>I am reading data from numerous excel worksheets, but the performance is slow since I am fetching each col directly. Is there a way I can read the entire UsedRange into memory with one call? Then process the rows/cols locally?</p>
  
  <p>The code I have is basically this:</p>
  
  <pre><code>xlWorkSheet = (Worksheet)_xlWorkBook.Worksheets.get_Item(1);
  var range = xlWorkSheet.UsedRange;
  for (var rCnt = 2; rCnt &lt;= range.Rows.Count; rCnt++)
  {
      // Process column entries
  }
  </code></pre>