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

Help
, ,
1

Hello all,
I have one excel sheet contains employee details contains 39 managers. So i want to write new excel workbook with 39 managers employee details using for each loop. guide me in that .
how 39 excel sheet can create in same time.

Employee data
Employee data1314Ă—21 2.82 KB

2

Hi
welcome to uipath community
–use EXCEL APPLICATION SCOPE and pass the file path of excel as input
–inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt
–now use a BUILD DATATABLE ACTIVITY and create a datatable with column structure we want and get the datatable with a variable named Finaldt
–then use a FOR EACH ROW activity and pass the variable dt as input
–inside the loop use a ADD DATAROW ACTIVITY and mention the number of elements to be passed based on the number of columns we have to ARRAYROW property like this
{“value1”,“value2”,“value3”,“value4”,“valuen”}
and mention the datatable as Finaldt

–next to this use a WRITE RANGE ACTIVITY and mention the sheetname as row(“yourcolumnname”).ToString
and input datatable as Finaldt and range as “” and enable ADD HEADERS property

–while still being inside the loop use a CLEAR DATATABLE activity next to this WRITE RANGE activity and pass the input as Finaldt

Cheers @ravindra.muluk

3

Hey sir,
In that sheet one column name contain total work hours so for that what will be the variable ?

4

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

5

sir,
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 .

6

In write range what will be workbook path ?

7

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 .

8

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

9

hello ,
Anyone can help me in that ?

1 Like
10

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

Cheers @ravindra.muluk

11

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

1 Like
12

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

13

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

14

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

15

hello,
Anyone can help me in that ?

16

hello,
Anyone can help me in that ?

17

whats the problem you are facing??

18

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 ?

19

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

20

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