Processing excel documents in BizTalk

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Processing excel documents in BizTalk

Viewing 1 reply thread
  • Author
    Posts
    • #20013

       Can I receive EXcel documents in BizTalk? If so, how should I configure BizTalk to receive excel files?

      Please help

      Thank you

    • #20014

      There is not an out-of-the-box way to process XLS files.  BizTalk does a great job of processing CSV and XML Excel files.  If you can save the Excel file as XML, you can configure BizTalk as you would for a normal XML file.  A CSV Excel file is just a flat file.  You can use the flat file schema wizard to generate a schema for the file, and use a flat file dissasembler pipeline component to receive the flat file into BizTalk.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.