How to write cell start from cell A2?

[Aditya_Nugroho]

Hello. I am beginner for RPA, especially UiPath. i have some task from my lecturer. I want to write cell from master data (master.xlsx) to (output.xlsx). i am use for each row for specific column. And then, i want to write cell to output.xlsx start from cell A2. Because A1 is field name / column name. I just get the data from master.xlsx, without header. Can you help me for this problem? Thanks!

[NIVED_NAMBIAR (NIVED N)]

Hi @Aditya_Nugroho

Welcome to forum

First u can a intialise a counter variable with intial value of 2

Then use for each row to loop through each row of the datatable

Inside the loop, do the following:

Use write cell activitiy with cell value as "A"+counter.ToString

Then increment the counter by one using assign activitiy

counter=counter+1

Regards

Nived N

Happy Automation

[Aditya_Nugroho]

THANKYOU! IT WORKS!!
I’m lacking at value of counter variable. and then, i add the value of counter variable!