Excel delete column

[happyfeat87 (Kowalski)]

Hello all.
I removed a column from 2nd position (SheetName) and now a duplicate column is getting created in the last colmun(Screenshot) .

[Lak_Ui (Lakshmi)]

this is because you are overwriting in the existing excel…you will have to delete everything in the excel and then write new datatable

[loveleet_Saini]

Hi @happyfeat87 !
Try running in debug mode giving a breakpoint So that you can see what’s wrong.

[muhammedyuzuak]

Hi @happyfeat87,

Cause of the problem,

@Lak_Ui

this is because you are overwriting in the existing excel…you will have to delete everything in the excel and then write new datatable

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.

Regards,
MY