Preserving formatting on excel Overwrite not working

aldoacosttaa

Hello Alteryx community,

I was wondering if anybody knew why the excel output in my dataflow is not preserving the format from before after I overwrite it. I clicked the preserve formatting on overwrite (range required) in the configuration window for my output but still no success. I want it to output into a table format on excel

let me know if anybody had had this same issue or potential clues to solve this..

Thank you so much

LindonB

Hi there,

I've not experienced that issue exactly, but I've encountered cases where the formatting can't be maintained. While things like formatting the cells to be numeric or in some other format should be maintained, other tasks like cell color often get moved around - especially as the shape of the data (such as length) changes. 

I'd first start by making sure you have everything configured correctly. Make sure you can a file location with the range of cells to override defined as "C:\\Users\\Folder Name\\Subfolder Name\\MyExcelFile.xlsx|||Sheet1$A1:Z99". Then make sure that you preserve the formatting. 

If it's still not working, you can also use conditional formatting in Excel as a way to maintain some column formatting even with the data changing. Additionally, let us know what kind of formatting is being overwritten or provide an example, and I can dive deeper.