How to append each row data in excel

Learn Academy Feedback
,
#1

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

#2

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

#3

Can you post the code?

#4

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.

#5

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

#6

Is it possible to attach your workflow.

#7

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

#8

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

Regards,
Mahaling Patil

1 Like