Posted 3 August 2017, 2:34 pm ESTPlease help to indentify which version i can use to support excel formats(XLS and XLSX). currency i am using Spread for BizTalk, version 18.104.22.1685. 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.
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
Replied 3 August 2017, 2:34 pm EST
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....