You might need to re-think your approach, I would try and build an HTML table output with a .xls extension , with any luck it will open in Excel by default.
I've used ODI to write HTML tables in emails using a combination of XMLELEMENT and XMLAGG function, you can control cell properties like Bold, background colour etc.
You can use a ODI Proc for this, store the XML output in a table, unload that table.
PeakIndicators_Alastair, I do have similar requirement to generate HTML table in email body through ODI using few SQL statements, appreciate if you could provide the code you created to generate the HTML table.
Thanks in advance.