As far as I know, it's not possible. If you want a particular format in
Excel, the choices are basically
1) write VBA code that exports the data (probably from a query rather
than a report) and then manipulates Excel to format the worksheets
exactly the way you want them.
2) create a pre-formatted workbook and use TransferSpreadsheet to export
data from a query into named ranges in the workbook. See
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html for
information on what's possible here.
