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
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Stef_99
ashokkarale
lrtetala
anjani_priya
Ajay_Mishra
Anil_G
samantha_shah
Hacene_SENDEL
Happydayyy
Sathish_Kumar_S