I have a loop, reading a bunch of exile files to a temporary datatable, and then appending it to a single excel file with the “Append Range” activity.
Problem is, that the appended data starts from column J, instead of column A.
I have narrowed down the problem to the format of my destination excel file - the three header columns do not have data in all of the cells, and if I add anything in the empty cells, the activity works fine (yellow “test” cells in the screenshot).
Technically I could leave the dummy data and change the color to white, but I would prefer not to tinker with the destination. Any thoughts how i can avoid that?