Specific row count need to calculate and paste in another report

[chaitanyaKumar]

Hello Community,

I have an output excel sheet which will get the process output details.

In those details i need to get the count of L comun P,NP,I as showing in the screen shot

i.e how many P,NP,I are there in the L column

Those details(count) need to paste in another sheet.

Can you please suggest the flow how to get those count in another sheet

Regards

[Rahul_Unnikrishnan]

Hello @chaitanyaKumar

You can use the excpression as below to get the count.

(From d in dtKeys.AsEnumerable
let cnt = dtData.AsEnumerable.Where(Function (x) x(“ColumnName”).toString.Trim.Equals(d(0).toString.Trim)).Count
let ra = new Object(){d(0), cnt}
Select dtReport.Rows.Add(ra)).CopyToDataTable

ColumnName is the column name.

you can refer to below post.

Get the Count of column values (possible values) in a Data Table using LINQ and extension methods?

I have a table like this. STATUS LEVEL RETURN IN ORDER OUT RETURN OUT RETURN IN SHIP OUT ORDER OUT RETURN OUT SHIP IN …

[muhammedyuzuak]

Hi @Rahul_Unnikrishnan,

First of all, read the excel as a datatable(dt).Then you can filter the cells you want to write to excel as follows.

dt.Select("[ColumnName] = ‘NP’").Count.ToString
dt.Select("[ColumnName] = ‘P’").Count.ToString
dt.Select("[ColumnName] = ‘I’").Count.ToString

Regards,
MY

[jack.chan]

try this
d.xaml (19.9 KB)
case_Details.xlsx (12.2 KB)
Total_Cases.xlsx (8.9 KB)

[chaitanyaKumar]

Hi Jack,

I am facing this error.

[jack.chan]

update your uipath.excel.activities to latest version

[chaitanyaKumar]

Hi Jack,

I run your xaml, but it not taking any data. but the process is completed and it shows the excel time as run time. but no data is updated in excel.

Regards,