SSIS Excel Destination Formatting Problems

Ok. I've been messing around with exporting data to excel using an Excel Destination. I keep having formatting problems specifically with dates, numbers and text (if the text looks like a number). I am exporting to a range.

1) If set the FirstRowHasColumnNames to true, format the appropriate cells in the header, and the range is set to the row of column headers only, the formatting does not apply.

2) If set the FirstRowHasColumnNames to true,include a blank row after the header, format the appropriate cells in the that row and set the range to both rows, the formatting does apply but I get a blank row after the header line.


3) If set the FirstRowHasColumnNames to false, format the appropriate cells in the first row, and set the range to that row, the formatting does not apply.

I cannot use VBA or install excel on the server and manipulate it via VBA.

Is there any way to delete the row via a query using OLEDB? I seem to have read you can blank out a line but not delete a row using this method.

Is there any way to format the columns in SSIS?