How to append each row data in excel

Hi, all

I have scenario that, I want to append a each and every row in a separate excel , but in my case last row of the excel Is appending in five times . but I want all the row should append in the separate excel

@mohan2 By using append range activity you can achieve this.

Can you post the code?

Hi @mohan2

Instead of directly appending data to excel first add to Datatable by using Add Data Row. After for each row loop you can use a single Append Range activity to add to excel file.

Regards,
Vijay Kumar C.

I am using append activity only, but last value only is appending

Is it possible to attach your workflow.

I should not attach the workflow seems , sorry it is confidential

I have attached workflow please go through it and let me know.AppendrowtoExcel.zip (34.1 KB)

Regards,
Mahaling Patil

1 Like