Which version of Farpoint Adapter to use to support both Excel formats XLS and XLSX

Posted by: sivakumar25-fp on 3 August 2017, 2:34 pm EST

  • Posted 3 August 2017, 2:34 pm EST

    Please help to indentify which version i can use to support excel formats(XLS and XLSX). currency i am using Spread for BizTalk, version 3.0.6.2005. I have created my schema with XLS format(which supports only XLS files), if i create Schema with XLSX format which supports only XLSX files. Please help how to create schema which supports both the Excel(xls and xlsx) as input files.
  • Replied 3 August 2017, 2:34 pm EST

    Sivakumar,

    If my understanding is correct then you are looking to use a single BizTalk Disassembler (in the Receive Pipeline) through which you can parse files with multiple formats (XLS, XLSX etc). Currently, you are able to achieve this by using multiple receive pipelines..

    If the above is correct, then you can parse multiple files by using these steps:

    (1) Create 2 Schema (one with XLS and another with XLSX).

    (2)  Add both the schema to the "Document Schema Collection" property of Spread for BizTalk Disassembler component.

    Now, go ahead and parse either XLS or XLSX file and it should work perfectly.

    One thing you need to be careful here is that the layout and the data structure of both the template files (XLS and XLSX files) should be 100% similar. 

    Let me know if you have further questions....

     

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels