title: Record count for Excel file with extension CSV
body: <p>I am trying to count the record of excel file with extension csv with the following code but I am not getting exact number of rows. </p>
  
  <pre><code>int lineCount = 0;
  using (var reader = File.OpenText(@fileFullPath))
  {
      while (reader.ReadLine()!= null)
      {
          lineCount++;
      }
  }
  </code></pre>
  
  <p>Can anyone please advise me on this.</p>