Getting complex excel documents into xml format is a total pain.
That's why we wrote Bumblebee.
Using a template based system, you can easily map values from an excel document to xml values, nodes and attributes and export directly to XML. And it's written using Adobe Air, so it works for both Mac and PCs.