Clear write cell data

I have an automation that goes on a loop and within that loop it uses two “Get Full Text” activities to get data, and then uses “Write Cell” activity to paste it into a excel workbook template.
However when it loops and only one of the two “Get Full Text” activities manages to find data, the previous data from the 2nd “Get Full Text” is still stored, resulting in it pasting that previous data into the new excel workbook template.
Is there any way to fix this by transferring the “Get Full Text” data into a datatable or just “Clear Cell” in the loop?

1 Like


After writing into Excel cell and just assign empty value to that string like below.

       String getFullText = String.Empty


Thank you for the help, it works flawlessly!

1 Like

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