Excel automation


#1

hello all,

I’m currently working with excel automation using UIPath. There are around 4 mapping tables in excel from which an excel spreadsheeet has to be created. The mapping tables don’t follow the same sequence. There is a primary key against which all the other columns need to be filled. Every column needs to be extracted from a different table. How can I iterate through the columns as well as the rows. I used for each row for row iteration and for each activity for column iteration. But how can I increment the column from A1->A2->A3 and row as A1->B1->C1???

Suggestions welcome.

Thank you
Amitha


#2

Hi @Amitha,

I was not able to understand your question, but maybe it can help you: