Excel operations to fetch columns

Help Studio
, ,
1

In Excel, First column consists of 3 bananas , 2nd 3 apple and 3rd 3 oranges

  1. Bot should check how many bananas, apples, orange are their? Count it

  2. Add one other fruit name(Mango) at one of the banana place& run , show me the count of mango and banana now

Anyone please help me with code?

2

Hi @Shravan_Pintu

bananaCount = dt.AsEnumerable().Count(Function(row) row("Column1").ToString.Equals("banana", StringComparison.OrdinalIgnoreCase))
appleCount = dt.AsEnumerable().Count(Function(row) row("Column1").ToString.Equals("apple", StringComparison.OrdinalIgnoreCase))
orangeCount = dt.AsEnumerable().Count(Function(row) row("Column1").ToString.Equals("orange", StringComparison.OrdinalIgnoreCase))

Regards,

3

@Shravan_Pintu

This image depicts a sequence of activities in an automation workflow, where a workbook is read, counts of specific items (banana, apple, orange) are assigned from the data, and those counts are then written to separate lines. (Captioned by AI)
This image depicts a sequence of activities in an automation workflow, where a workbook is read, counts of specific items (banana, apple, orange) are assigned from the data, and those counts are then written to separate lines. (Captioned by AI)818×815 42.2 KB

Input:

image

Output:

image

This image shows a UiPath workflow sequence for reading an Excel file, counting the instances of various fruits (banana, apple, orange, mango) in a specific column, and writing the counts to the output. (Captioned by AI)
This image shows a UiPath workflow sequence for reading an Excel file, counting the instances of various fruits (banana, apple, orange, mango) in a specific column, and writing the counts to the output. (Captioned by AI)818×968 51.2 KB

mangoCount = dt.AsEnumerable().Count(Function(row) row("Fruits").ToString.Equals("mango", StringComparison.OrdinalIgnoreCase))

Input:

This image shows a spreadsheet with three columns labeled "Fruits", "Type", and "ID", containing various fruit names, their types, and associated codes. (Captioned by AI)
This image shows a spreadsheet with three columns labeled "Fruits", "Type", and "ID", containing various fruit names, their types, and associated codes. (Captioned by AI)813×493 9.05 KB

Output:

image

Regards,

4

Here Bot should replace one banana row with a mango & should check the count

5

@Shravan_Pintu

Try this

The image depicts a sequence workflow in a visual automation tool, reading data from an Excel sheet, counting the occurrences of different fruits, modifying the data, writing back to the Excel sheet, and logging the counts of each fruit. (Captioned by AI)
The image depicts a sequence workflow in a visual automation tool, reading data from an Excel sheet, counting the occurrences of different fruits, modifying the data, writing back to the Excel sheet, and logging the counts of each fruit. (Captioned by AI)818×1396 75.4 KB

Invoke Code:

' Find the first occurrence of "Banana" and replace it with "Mango"
Dim firstRow = (From row In dt.AsEnumerable()
                Where row.Field(Of String)("Fruits") = "Banana"
                Select row).FirstOrDefault()

If firstRow IsNot Nothing Then
    firstRow("Fruits") = "Mango"
End If

image
image885×260 10.7 KB

Input:

image
image616×536 8.05 KB

Output:

image
image702×532 9.27 KB

image

Sequence16.xaml (14.0 KB)

Regards,

1 Like
6

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