I figured out how to do this and found it useful so I thought I would share what I had learned in case other people might find it useful.

I didn't mean to offend anyone by ignoring the Excel destination. I just never found it very useful for what I needed to do. I have also found that an Excel file exported from SSRS can be a sloppy mess with overlapping fields and columns.

This is a free, reliable solution and it allows you to construct the spreadsheet the way you want it.