How can i write multiple excel workbook having employee details with manager name from same excel workbook?

its based on the process buddy
initially we can pass that as string variable itself and later if we want we can change the datatype of that string variable
Cheers @ravindra.muluk

not getting the output as per the requirement. only one sheet is getting created after execution.
expected result is : should create 39 excel sheets with 39 manager names .

In write range what will be workbook path ?

sample uipath.xlsx (10.3 KB)
can you create .xaml file for this ?

Want to create excel workbook with different manager names & there employee details using for each loop .

Hey sir,
Waiting for your reply. its too urgent.

hello ,
Anyone can help me in that ?

1 Like

Sorry for the delay in response
Did we try with this blog mentioned method

Cheers @ravindra.muluk

sir i am not getting the 39 excel sheets with 39 managers

1 Like

But when I saw the excel it seems like each manager has four records in them
And you want those four records for each manager to be in different excel sheet right
Then first we can create such separate datatable with the above post mentioned and then we can right that datatable back to a excel with write range activity

Cheers @ravindra.muluk

yes sir. Can u create .xaml file for this ?

how can i get total work hours of an employee within a week?

Anyone can help me in that ?

Anyone can help me in that ?

whats the problem you are facing??

I have one excel sheet contain employee attendance records having working hours so i want to who has work less than 45 hours in a week ?

sample uipath.xlsx (10.3 KB) Please check the reference excel file

the employee who has skipped the first in time & last out time, who has worked less than 45 hours. Need all this data to write in excel


can anyone help me in that ?

how to get data in excel who has work less than 45 hours in 5 days week ?