I am trying to write a column of my datatable back in my excel using datatable.DefaultView.ToTable(False,“Column Name”). This works perfectly fine for all rows (including duplicates) except the last row where nothing is written back in my Excel.
If I use the output function and a write line activity I can see, that in my datatable this row and column the value is given like I want it to have, but somehow it does not get written back in my excel.
Can you help?
Thanks a lot