Overwrite in excel

I write a text in excel ,how to aviod overwrite in excel when I reopen the process !


might be variable scope of “i” is incorrect, is the scope “Excel application scope” or higher? plz once check it.

Hi @homyz,

You can use Append Range activity, but you should make modifications because it need input as DataTable.


You can read the already existing excel file, so you get the corresponding DataTable and obtain its length. This length can be use to initialize you variable i (probably +1)