I have a workflow where I have 2 files dsr.xls as the transaction file and MT.xlsx as the master template.
I am doing a vlookup and there are around 2000 rows in the transaction table and activity works fine.
Unfortunately the time taken is close to 10 mins and it is not a great since we are automating a manual process. I am adding the .xaml file, if anybody can suggest some other logic to reduce the time taken to write the data would be of great help. I have to update 3 more columns like these so it would definitely increase the time 3 fold.