i am adding “validated” in a current row but while writing into the the excel its changing the the position of the the row its writing from A1 we need to identify the count of the row no. and add the “VALIDATED” in AU Column the same ROW NO. .
For this which you identify your current row…you will get the index of that row from the index in your for loop…check the for loop properties… now add index+1 is the row count in excel if you are reading data from row 1 in excel…if the reading changes then add the number accordingly
Use that in write cel with cell as AU+ (index+1).tostring
This is how you need to identify and write
Cheers
actually we getting the name from another file
the with that name we have to filter in this file
so if answer is applicable to this condition can you please elaborate
DO both the files look alike? I mean the data starts at same point and the values stay in same rows?
If yes then same I said above in for loop you will find the index value can get index and then open second file and use the index as stated above
else you can use a assign activity and increment by 1 to get the loop count as well
cheers
no both files does not look alike
Then how to you know manually where to paste?
if you are looking at some value in a column and then want to give the value beside it then you can use find/replace and find that row using the value you know . this will give you the cell address which contains row and the column. extract row and use it for your next activity to write the data
cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
sharazkm32
prashant1603765
V_Roboto_V
ashokkarale
Stef_99