Could any one suggest a way for deleting Excel sheet cell values after processing. Here I am using an excel sheet in my automation, for one rotation its working fine. While the loop is rotating for the second time, Previous values which i used are presenting there only. Is there any way to delete excel chell values or to close the file without saving(As in its intial state it wont have any excel values).
Use Write cell option. Give the sheet name “sheet1” and Range for ex. “A2:D25”.
Below field input “”. It will clear the contents in an given range
Would you agree that given answers are a workaround to simple activity that is missing? Or I can’t find it?
What if my Excel, that I’m trying to clear, is Dynamic? My range is from A2:F(?) → (could be 100, could be 10000). I want to clear everything after A2 and replace it with new data.
Since we don’t have a way to find last filled row, another missing activity (I believe) - what other options do we have?