Writing to excel file erasing existing formatting

[jmHoekst]

Hello,

I am using the Java Printwriter to write to an excel file. I have a template for my excel file, with some alternating line colors and a frozen pane so my header is visible when the file is scrolled down.

However, whenever I write to the file, all the background coloring disappears and the window pane unfreezes before my data is written.

Does anyone know why Java decides to erase everything in the file before it writes? Do I need to tell Java to append to the file instead of writing to it?

Thanks for the help.

[Norm]

Yes. The default is to replace. Read the API doc for the output constructor looking for the append parameter.