Writing after the last filled cell in excel

Hi all,

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?

Many thanks! :slight_smile:
Angel

HI

You can try Attached xaml, Please change the paths as you need.

Test_Excel.xaml (3.6 KB)
Thanks…

Hello,

I am sorry, but the file is empty…

Thanks!