If you’ve ever wanted or needed to parse Excel files using BizTalk, you can now. Some time ago FarPoint released a pipeline dissassembler component for BizTalk Server 2006 which is able to convert Excel files into XML. From their website:
Spread for BizTalk Server 2006 provides a complete solution for integrating Microsoft Excel data seamlessly into your BizTalk applications.
Spread includes a pipeline disassembler that parses Excel data (XLS, Excel 2007 XML, CSV, TXT) into XML, and a pipeline assembler that creates Excel (XLS, Excel 2007 XML) and PDF documents from XML data in BizTalk Applications.
Read more about Spread, download a trial or obtain a license here.