Excel Automation changes using uipath

[Shravan_Pintu]

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

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

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

please help with the code

[Kismet_Tosun (Kısmet Tosun)]

Hi, @Shravan_Pintu

I done for you. Here is it. Change folder path and try.

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

[ashokkarale]

@Shravan_Pintu,

Refer this:

Count the banana from excel

@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] 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)] Code: [This…