Please place the write range outside the loop
I guess you want to write all the data in datatable to excel
Cheers
@AbarnaKalaiselvam You need to place “Add Data Row” inside loop and “write range” outside loop.
no it doesnt work
@AbarnaKalaiselvam show your complete workflow.
no not working,im having nested loop
inside my second loop my add data row is present.
i tried the writerange both inside and outside the loop.
I beleive the issue is with build datatable…it should eb outside both for loop and before them
Because it is inside the table is getting reintialized always, so for every iteration new row is being added but old rows are removed
Cheers
yes @Anil_G thankyou
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.