How to append each row data in excel

Learning Hub 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