>I'll look at my old code. I'm pretty sure there is a way to do this with another member function [formular1c1()?? can't remember].
Not sure but I had to apply a full set of styles to define the sheet in the exact way I want. The previous version of my dataset to Excel was not doing much. This one format the headers, backgrounds, alignments, date formats and such.