Count Specific Column in the excel

Help
, ,
1

Hi Friends.

Please help!
How to count specific column in the excel.
1.I want to count all the row value of Email
2.I want to count all the row value of Id nVision.

Thanks in advance.

image

cheers:D

Happy learning :smiley:

2 Likes
2

@pattyricarte you can try Linq queries to get the count

2 Likes
3

@pattyricarte

Try this.

    Int emailCount = yourDT.Select("Email <> ''").CopyToDataTable.Rows.Count
5 Likes
4

CountColumnValues.zip (11.3 KB)
You can use this method which is in the above workflow to get the count…

2 Likes
5

I used your query but its showing this below error,
"19.4.4+Branch.support/v2019.4.Sha.6d308c7f5a32b559373887ae421ce7eaec8f8d24

Source: Assign

Message: Cannot perform ‘<>’ operation on System.Double and System.String.

Exception Type: System.Data.EvaluateException"

1 Like
6

Hi @lakshman, @Manish540, @kalyanDev

Thanks a lot :smiley: For the help!

cheers :smiley:

Happy learning :smiley:

3 Likes
7

@pattyricarte

Glad to help you. Happy Automation :grinning:

8

Happy Learning