Updating excel cell based on string in another cell

Help Studio
1

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.

image

2

@Grzegorz_Biernacki_PL

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

Reference

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

Thanks

3

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