How to append data into excel

Automation Studio
1

Hi Team,

I want to append the data into existing excel. In community edition, we don’t have Append file operation activity. How can we achieve this?

2

Hi,

You can use excel recorder activity to put data in your excel. Once you record then you will have to edit the macro recorded and check for last filled cell and begin writing data from next cell

Regards,
Amit Anand

3

Thanks Amit. Do you have code for finding last filled row?

4

Hi,

Kindly google for “macro to find last used row”. Check which one fits your use case.

Regards,
Amit

5

Okay. Thanks Amit…