Excel Pipeline Component
The
Excel Pipeline Component accepts Excel 2003-2007 .xls files. It
will parse each worksheet into a child node under the root node you
specify.
Here are the Pipeline Component Properties.
Here is an example XLS file.
The resultant XML file creates the Root Node “SHEETS” as specified in
the pipeline properties. The children of “SHEETS” are the
worksheet names listed in alphabetical order. I dropped 1200
Excel spreadsheets into a receive location and BizTalk parsed each
perfectly in less than 10 seconds.