title: Microsoft.Office.Interop.Excel how to get the correct last row?
body: <p>I am trying to use Microsoft.Office.Interop.Excel to get the row number of my excel file, which is 40424 rows. </p>
  
  <p>I have tried codes below:</p>
  
  <p><a href="https://i.stack.imgur.com/LEUma.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LEUma.png" alt="Debug Infos"></a></p>
  
  <p>They only returns 38304, which is not correct.
  What is the correct way to get the right row number?</p>