I am reading an empty excel from a share point and finding its row count (dataTable1.rows.Count). It is returning the value 1.
When I try the same with the excel in local drive, it is returning the value 0.
Have you guys came across this type of scenario. Why there is a difference in the output.