FarPoint Spread for BizTalk Server & Excel Integration
Folks,
I'm back after a fantastic vacation! Was recently investigating options to get the Excel file integrated with an existing BizTalk application and found out that FarPoint have a great product called FarPoint Spread for BizTalk Server which helps you do just that by automating the parsing of Excel message stream to XML message streams (also compatible with R2). It provides you a codeless solution to parse Excel spreadsheet into XML. At the design time, there is a wizard to help you develop a custom schema based on the Excel sheet and at the runtime, the Excle is parsed and dis-assembled into XML. Look at the following video:
https://www.farpointspread.com/biztalk/videos/SfBTV2-2.aspx
Very Cool!