Hello, I want to change all cell values that do not equal “ Complete “ to “Not Complete.” I tried using and an “IF”, “ Write Cell” and “Replace” activities but it is not working. I am using Studio X. [image]

How to change all cell values that do not equal "Complete" to "In Complete" using Studio X

Yoichi (Yoichi) December 10, 2022, 1:59am 2

Hi,

Can you try ForEachExcelRow activity instead of WriteCell as the following post?

Regards,

Topic		Replies	Views
How to remove all text values from numeric value column in Excel using Studio X StudioX studiox , question	3	761	January 15, 2023
Studio X is not recognizing excel values as numerical StudioX studiox , question	1	476	January 13, 2023
Replace value in column with another column if # Studio excel , studio , question , variables_management , linq , linq-query	4	79	July 12, 2024
Writing value into same Excel row after certain activities Help datatable , excel , studio	1	1205	October 21, 2019
How do I overwrite cells with a different value? Help studio	13	1100	October 23, 2020