Excel to XML & back to Excel, losing subtotals outline

[TIGREBLANCO]

Is is possible to export an Excel file to XML so I can send it to the client and then have him open it on his Excel without losing the subtotals' outline?
I have Excel 2003 and so far have not been able to accomplish this task. Maybe 2007 does the trick? Or am I just missing something here? (I'm new to XML)
Any help will be greatly appreciated.

 

[GlennUK]

Can you go back a step and explain why you are sending an Excel file as XML?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[TIGREBLANCO]

Sure, for some reason the client wants to have the data in XLM format (I believe they'll plug it into their CRM or something from the XML file) but they also need to be able to open the file from Excel. I find this to be an unnecessary step myself but that's what's on the contract.
Lets rather assume the data is coming from SQL server (which at this point is actually what will happen most of the times, as opposed to the data coming from Excel) so from SQL we have to put the data in XML but we also have to make sure when the file gets open in Excel the Group Outlines show properly (those lines with [+] and [-] signs to expand/contract the grouped data).
I can email you a sample file that shows what we are looking to get at the end.
What I've read so far tells me that the XSLT would be the key to this solution but not sure.
Hope somebody out there has done this before and can point me on the right direction.
Thanks.