I'm trying to export the results of a query to an excel worksheet that already has formatting defined on the columns. There are two "header" rows already present in the worksheet and these have different formats that the actual data that I'm exporting. The data transformation seems to work OK putting my data below the two heading rows, but the data rows pick up the formatting from the second heading row. I'm also seeing that when a cell contains and empty string as it's value, the following row looses all formatting for the cell for the rest of the worksheet.

Is there some way to keep the formatting from being overridden during the export.

Thanks

Hello, curious if you found a solution to this. I have
the same formatting problem when exporting to excel. If
the first (example) 10 rows have data, and then one field
is blank, the next row of data i get a single quote
before the characters...which messes up anything to do
with numbers because excel wont perform the calculations
on the cells with the single quote...quite frustrating.
Ive searched for a solution, but havent found one
yet...if you have found one, please let me know.

Thanks

columns. There are two "header" rows already present in
the worksheet and these have different formats that the
actual data that I'm exporting. The data transformation
seems to work OK putting my data below the two heading
rows, but the data rows pick up the formatting from the
second heading row. I'm also seeing that when a cell
contains and empty string as it's value, the following
row looses all formatting for the cell for the rest of
the worksheet.