I want read file excel from folder (loop) and write cell in another file excel.
round 1 run completed and correct.
but I have a problem in round 2 , I want to write cell after row in file previous. (in highlight yellow)
Please guide me about it.
I want read file excel from folder (loop) and write cell in another file excel.
round 1 run completed and correct.
but I have a problem in round 2 , I want to write cell after row in file previous. (in highlight yellow)
Please guide me about it.
Read spreadsheet to datatable, this gives easy read-write-access to data, then write back data to spreadsheet.