Unfortunately, the XML for Excel report of SQL Compare does not show the DDL for any objects. You can still save as XML. Excel 2013 at least can open the "plain" XML file and you can see the creation scripts from both sides.
Older versions of Excel may require you to supply the XSD (schema definition) so that Excel knows how to display the file. (see http://sdk.red-gate.com/index.php/SQL_C ... XML_import
- you can extract the XSD from the XML Schema Collection).
Otherwise, you can request this as a feature in Red Gate's Uservoice site: https://redgate.uservoice.com/forums/14 ... uery=excel