How to get entire row data

[Sai.Srinivas]

Hi,

I have excel sheet which consist of attendance data.

i want to calculate no of working days, present days, Planned leaves, per day salary

how to count to present days in excel.

Attendence.xlsx (13.6 KB)

Please check this excel sheet and please provide .xaml file which could be really helpful

Regards
Sai

[Anil_G (Anil Gorthi)]

@Sai.Srinivas

For all these operations you dont need to do from UiPath…all of these are directly available on excel itself…

You can use countif,Sum and other formulae as needed to calculate all of these values directly on excel itself

Cheers

[Sai.Srinivas]

@Anil_G

I want to count no of p in UiPath. How to do it and let me know in UiPath and also if morethan 3 PL then i need to make abscent for 4th PL

[arivu96 (Arivazhagan A)]

HI @Sai.Srinivas

Apply Excel Formula in cell
=COUNTIF(N2:AR2,"P")

Regards,
Arivu

[Sai.Srinivas]

How to do using Datatable not in excel can u provide .xaml file

[Gokul_Jayakumar (Gokul Jai)]

Hello @Sai.Srinivas
You can achieve this by Excel formulas and autofill activities.
refer the Excel sheet2 for Formula
Attendence.xlsx (15.8 KB)

Refer to this Thread to know more about the Autofill formula

UiPath Tutorial | Uipath Auto Fill Range

[arivu96 (Arivazhagan A)]

Hi @Sai.Srinivas ,
Refer below xaml file.
Attendance.xaml (11.0 KB)

Regards,
Arivu

[Sai.Srinivas]

@arivu96

[arivu96 (Arivazhagan A)]

Hi @Sai.Srinivas ,
Use updated xaml file

Attendance.xaml (16.2 KB)

Regards,
Arivu