Perl - Excel FAQ
and this example: Spreadsheet::WriteExcel

And there's a XML::SAXDriver::Excel, for transforming Excel to XML.

or there's the win32 OLE route