This content has been marked as final. Show 1 reply
I'm not sure that I understand how this relates to replication. It would probably be more appropriate in a different forum.
Personally, when I've needed to do this, I've created a Java stored procedure and used one of the Java APIs that are out there to support generating XLS files. Potentially, if you only need to support more recent versions of Excel, it is probably possible to create an XML file that Excel will open in multiple worksheets though I've never bothered to learn enough about the various Excel file formats to be able to guarantee that.