How to get entire row data

Help Studio
, ,
1

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

2

@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

3

@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

image
image800×285 4.32 KB

4

HI @Sai.Srinivas

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

Regards,
Arivu

2 Likes
5

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

6

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

7

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

Regards,
Arivu

8

@arivu96

image

9

Hi @Sai.Srinivas ,
Use updated xaml file

Attendance.xaml (16.2 KB)

Regards,
Arivu

2 Likes
10

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