Value over lap in excel when adding data

Help
1

Hi, I tried to create an automation that copies The total expenses in Expenselt (UIPath Create expense report sample). But whenever it saves its values in excel it overlaps. Please help. Thank youRecording-Excel.xaml (50.1 KB)
Employees.xls (19 KB)
MyDT.xlsx (8.4 KB)

2

image
image1366×768 66.7 KB

This rowindex is not working on me

3

What is the value of variable “row”. Is the assign inside for each row?

4

@rmfeliciano rowIndex variable is used anywhere. Why ur assigning MyDT.Rows.index(row)+1 to index. And one more thing ur using 2 for each datarow loop so better change loop variable for one loop from row to some other value. I think that might work because MyDT.Rows.IndexOf(row) is confusing which “row” variable has to be consider between two for each datarow loops.

1 Like
5

I make some changes.
image
But still have some errors

6

RecToExc.xaml (38.6 KB)
Employees.xls (19 KB)

7

@rmfeliciano print each value ur getting from get text activity using message box or writeline. Check whether u getting same value or different value each time. change the variable for each datarow, using 2 row variables one inside other it will be confusing so change one among them.

1 Like
8

I already figured out my error. I just remove the new datatable then add column in my employee data table. Thanks for the reply.

2 Likes