I tried to use the workbook version of the writecell activity to clear a number of columns lets say A:H and then set the Text parameter to “”. This causes the workbook I’m trying to clear data from to be corrupted. Also takes ages for the activity to complete.
The process is fine if I use an Excel application scope and the excel version of the write cell activity, and the activity runs quite quickly.
I don’t have a blocker because I can use the Excel version but maybe the issue should be checked?
attached is an example
WriteCellClearContents.zip (24.9 KB)