I want to count the total number of rows enetered in csv but when it print,it only shows half rows
Try writing the dt into another cav and check if there are missing rows and validate what happened wrong in your worflow before doing count
I think in count it removes the duplicate name,so what should I do
What do you mean by it removes duplicate name?
Do you have remove the duplicate value before getting the count?
some users used different software with the same name
Ideally it will read all… if you are filtering on something then you need to give correct rules. Can you show screenshot of what you want and what is happening in file
Can you give us more details on the issue?
To getting the row count just use
This might be caused by a blank row in your data.
Check the CSV file and see if you have an empty row.
Actually, I want to extract the users who have used the software’s for the last 24 hours.If I count manually, it is 182 but when I used dt.rows.count,to string in log it prints=91
@Cuberoot From where you are extracting the users?and check the excel sheet has all users which was extracted.
yes.I has extracted all the users
Are you doing any filtering on dt after reading? .
Or in your excel are the formatting of few cells different?
How are you reading excel and after read do a count a check if its peoper
Can you show the excel sheet with data?