Count the banana from excel

Help Studio
, ,
1

im getting error here

given:
bananaCount = fruitTable.AsEnumerable().Where(Function(row) row.ItemArray.Contains(“Banana”)).Count()

The image shows an expression editor with a VB.NET code snippet that counts the number of rows in a DataTable () where any cell contains the word "Banana". (Captioned by AI)
The image shows an expression editor with a VB.NET code snippet that counts the number of rows in a DataTable () where any cell contains the word "Banana". (Captioned by AI)916×356 7.82 KB

count the banana from excel

image
image404×222 2.4 KB

2

fruitTable.AsEnumerable().Count(Function(row) row(0).ToString().ToLower() = "banana")

Hope it helps

3

Hi @Shravan_Pintu

Here is it.

Data.xlsx (7.9 KB)
Main.xaml (39.8 KB)

4

@Shravan_Pintu,

Use this LINQ. It will give you count from whole datatable.

intCount = (From row In dtInput.AsEnumerable() From col In dtInput.Columns.Cast(Of DataColumn) Where row(col).ToString().Equals("banana", StringComparison.OrdinalIgnoreCase) Select row(col)).Count()

Input:

image
image353×148 4.22 KB

Output:

The output window shows a debug session indicating that test code execution started, counted 4 bananas, and completed in one second with no errors or warnings. (Captioned by AI)
The output window shows a debug session indicating that test code execution started, counted 4 bananas, and completed in one second with no errors or warnings. (Captioned by AI)512×240 13.7 KB

Code:

This image is a screenshot of a UiPath workflow that reads data from an Excel file, counts how many times the word "banana" appears in the data, and logs the count. (Captioned by AI)
This image is a screenshot of a UiPath workflow that reads data from an Excel file, counts how many times the word "banana" appears in the data, and logs the count. (Captioned by AI)673×649 21.9 KB

5

The image shows a workflow with an assignment activity saving an enumerable from a DataTable to a variable named "mango" and a Write Line activity that outputs the string "Mango" followed by the string representation of the "mango" variable. (Captioned by AI)
The image shows a workflow with an assignment activity saving an enumerable from a DataTable to a variable named "mango" and a Write Line activity that outputs the string "Mango" followed by the string representation of the "mango" variable. (Captioned by AI)678×323 10.6 KB

how can i replace one banana with one mango?

The image shows a workflow in UiPath Studio involving data assignment and writing output concerning mangoes, with the output panel displaying results for various fruits and the execution status. (Captioned by AI)
The image shows a workflow in UiPath Studio involving data assignment and writing output concerning mangoes, with the output panel displaying results for various fruits and the execution status. (Captioned by AI)1734×819 40.6 KB

im getting mango as 0

dtfruit.AsEnumerable().Count(Function(row) row(“Fruit1”).ToString.Equals(“mango”, StringComparison.OrdinalIgnoreCase)).ToString()

AND the output shoud be
banana:2
apple:3
orange:3
mango:1

6

@Shravan_Pintu,

Modify this way

intCount = (From row In dtInput.AsEnumerable() From col In dtInput.Columns.Cast(Of DataColumn) Where row(col).ToString().Equals("mango", StringComparison.OrdinalIgnoreCase) Select row(col)).Count()

7

This image shows a Robotic Process Automation (RPA) workflow in UiPath Studio, specifically depicting a sequence that assigns a value to the variable and then writes the value of to a log, with the Output panel displaying log entries of different fruit counts and an execution end time. (Captioned by AI)
This image shows a Robotic Process Automation (RPA) workflow in UiPath Studio, specifically depicting a sequence that assigns a value to the variable and then writes the value of to a log, with the Output panel displaying log entries of different fruit counts and an execution end time. (Captioned by AI)1626×776 35.4 KB

Getting output as zero

(From row In dtfruit.AsEnumerable() Where row(“Fruit1”).ToString().Equals(“mango”, StringComparison.OrdinalIgnoreCase) Select row(“Fruit1”)).Count().ToString()

8

@Shravan_Pintu,

Use this LINQ as it is. No need to change anything like column name or anything. This query will automatically take column names

(From row In dtInput.AsEnumerable() From col In dtInput.Columns.Cast(Of DataColumn) Where row(col).ToString().Equals("mango", StringComparison.OrdinalIgnoreCase) Select row(col)).Count()

9

The image shows a UIPath Expression Editor with a compiler error message indicating an issue with implicit type conversion from 'Integer' to 'String' in a LINQ query. (Captioned by AI)
The image shows a UIPath Expression Editor with a compiler error message indicating an issue with implicit type conversion from 'Integer' to 'String' in a LINQ query. (Captioned by AI)899×638 37.5 KB

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.