Read all file excel in folder and write range

okey i use merger datatable, can i add some data to the merger datatable ?
and then every loop it will save in that merger datatable, after loop is done.
i write again all the merger datatable to new file excel