I removed a column from 2nd position (SheetName) and now a duplicate column is getting created in the last colmun(Screenshot) .
this is because you are overwriting in the existing excel…you will have to delete everything in the excel and then write new datatable
Hi @happyfeat87 !
Try running in debug mode giving a breakpoint So that you can see what’s wrong.
Cause of the problem,
As a solution, you can print a different sheet or if you want to use the same sheet, you can use the ‘delete range’ activity.