Eric's BizTalk 2004/2006 blog

I've created a BizTalk Excel File decoder pipeline.  It 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.

<Sheets xmlns="http://your.name.space.here">
  <First>
    <RowData>
      <Column1>row1column1</Column1>
      <Column2>row1column2</Column2>
    </RowData>
    <RowData>
      <Column1>row2column1</Column1>
      <Column2>row2column2</Column2>
    </RowData>
    <RowData>
      <Column1>row3column1</Column1>
      <Column2>row3column2</Column2>
    </RowData>
  </First>
  <Fourth>
    <RowData>
      <Column1>Fourth</Column1>
    </RowData>
    <RowData />
  </Fourth>
  <Second>
    <RowData>
      <Column1>Second</Column1>
    </RowData>
    <RowData />
  </Second>
  <Third>
    <RowData>
      <Column1>Third</Column1>
    </RowData>
    <RowData />
  </Third>
</Sheets>

To learn more about obtaining this Pipeline Component, go here.

Something recently changed on a development server that disabled the ability for IE to open xml documents.

I resolved it by following these steps:

1. From start menu select run

2. Type 'regedit' and press enter. This will bring registry editor.

3. From the regedit menu select Edit and then Find

4. Type "HKEY_CLASSES_ROOT\Mime\Database\Content Type\text/xml" in the 'Find What'

5. Regedit will find the content that is related to that entry

6. Verify your classid CLSID={48123BC4-99D9-11D1-A6B3-00C04FD91555} ?

7. Verify your Extension=.xml ?

8. Verify your Encoding=hex:08,00,00,00 ?

If all those values are correct, but still not working, do the following:

1. From start menu select run
2. Type 'regsvr32 msxml3.dll'
3. Click OK on the dialog box.