'Preserve formatting on overwrite' not working as expected with respect to cell borders

Question

Hello  folks,

I am using the 'Preserve formatting on overwrite' option along with "Change the entire file path" option to overwrite few rows in an existing excel sheet. The excel sheet that I wish to overwrite consists of cell and table borders, and when I overwrite these cells using Alteryx, there are few cells where the cell borders are preserved,  and then for few cells these borders disappear. Not sure if others have faced this issue. Any help on how to resolve this is  appreciated.

Podoseb0 · Answer

@SylwiaDragon Have you tried creating a batch macro, which gets the input as you've shown, and just before the output tool deletes all Null columns? Doing so you'd avoid having all those nulls, which also means you can give a specific cell as a range (C17:C17).

SylwiaDragon · Answer

No, it's the same.

I tried to mess around with different named ranges and it didn't help either.

gabrielvilella · Answer

@SylwiaDragon if you change from Null to empty, does it work?