Updating excel cell based on string in another cell

Hi all,

I’m trying to go through excel file/DT (I tired with both approach, looping through excel file, and importing spreadsheet as DT), by cells which contain particular string, and update cell next to them with particular text
I’ve used “conditionRow.ToString.Contains(“mycriteria”)” statement in IF activity, but although there are cells which contains text which I am looking for, cell next to it is not updated.



Check below a usecase of writing to datatable and write back to excel


Hope Using this you can relate your issue, If not can you share the sample Input Output files


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.