I am bulding an automation in which I would need to write data after the last filled cell in excel file.
I have created a count var: Counter = DT.Rows.Count
After that, I use write cell activity, and I put this in cell to fill: “C” + (Counter + 1).ToString, but this is not working. I put “1” so robot should write after counting the lines.
Do you know how can I do it?