Excel mapped

[ashishmani (ashish mani tripathi)]

i want to copy data from one excel and paste to to other excel with respective columnsBook2.xlsx (8.0 KB) Book1.xlsx (8.3 KB)

book1 a1-sucess
b2 - sucess
a2- fail

[allurai_india ((Allu)Alluraiah Yallapragada)]

Main.xaml (10.6 KB)

this may not give you exact solution …but this will help you

[ashishmani (ashish mani tripathi)]

@allurai_india please mention the package you are using

[allurai_india ((Allu)Alluraiah Yallapragada)]

2019.10.

[allurai_india ((Allu)Alluraiah Yallapragada)]

1)Read range -----Book1-----OUPUT-Book1
2)Read range-----Book2------OUTPUT-Book2
3)For each row1_Book2 in Book2
For each row2_book1 in Book1
if
cint(row1_Book2.Item(“tickets”)) = cint(row2_book1 .Item(“tickets”))
Assign : i = (Book2.Rows.IndexOf( row2_book1 )+1)
writecell :
Range : “B” &I+1
IMPUT:row1_Book2(1).ToString