I have a use case like having two excel files say
- result.xlsx (In the Bottom) for reference |attachment](upload://q4Coiprl2dXmMSe6IfiEaxpVmBe.xlsx) (8.4 KB) Two.xlsx (8.4 KB) one.xlsx (8.4 KB)
i need to find the row which having set-text(column 3) in 1st excel and get the source (column2) for that text column that contain “Set-Text” and i have to compare that source (column2)name in 2 excel and respective field(Column 3) from the 2nd excel should replace the field (column 3) in the 1st excel.
I have attached the excel files of input and output both.
Help me to solve this …
Thanks in Advance…
sriramresult.xlsx (8.4 KB)