Getting redundant data while reading csv file

Help Activities
, ,
1

Hello,

We are trying to perform operations on csv file, but while getting the row count, count is fetched 37, whereas the file contains 36 rows.
After checking value at 37th row, data is coming as null, whereas post applying conditions to check for data is null or empty, condition is not satisfied.
Seeking help to resolve this at the earliest

2

Hi,

Can you elaborate your problem?
If you want to delete the last row, the following will work.

dt = dt.AsEnumerable.Take(dt.Rows.Count-1).CopyToDataTable

image

Regards,