FarPoint Spread for BizTalk is a pipeline disassembler that:

• Allows you to integrate Microsoft Excel data into your BizTalk applications by parsing incoming Excel spreadsheet stream messages into XML

• Codelessly automates the parsing of XLS message streams into XML message streams without the need for Microsoft Excel

• Supports comma-delimited (CSV) and tab-delimited (TXT) Excel files in the design time wizard and run time component

• Includes an easy wizard interface to create custom schemas

• Allows multiple schemas to be set at design time to allow the runtime component to support multiple spreadsheet layouts within a single receive pipeline

• Optionally includes or ignores hidden columns in incoming Excel (XLS) streams from the resulting XML

• Optionally copies spanned cell data in incoming Excel (XLS) streams, to each individual cell in the span, in the resulting XML

• Optionally includes or ignores sheet names in incoming Excel (XLS) streams as attribute data in the resulting XML

• Allows you to design the schema by selecting the range of record item data in each sheet of an Excel (XLS) spreadsheet

• Allows you to specify each column of incoming data to be represented either as an element or as attribute data in the resulting XML

• Allows you to specify the XML data-type for each column of the incoming Excel stream.

• Allows you to specify the element or attribute name of each data element in the resulting XML

• Can be added to the Decode, Disassemble, or Validate stages of the receive pipeline of BizTalk

• Has its design-time elements fully integrated into Visual Studio 2005

• Complies with CLS with the exceptions where non-CLS-compliant Microsoft classes and interfaces are required

• Latest version tested with BizTalk 2006 R2

FarPoint Spread for BizTalk is a pipeline assembler that:

• Allows you to codlessly create Excel (XLS and Excel 2007 XML) and PDF documents from the XML in your BizTalk Application

• Includes a Spreadsheet Format Designer to allow you to specify the formatting of the resulting document.

• Allows you to make the following formatting specifications in the resulting document:
  • position and size images
  • set row and column backcolors
  • set row and column forecolors
  • set row and column fonts
  • set column alignment
  • set column number, date-time, and text formatting
  • set column widths
  • set row heights
  • specify the display of gridlines
  • specify the display of row and column headers
    

• Has its design-time elements fully integrated into Visual Studio 2005

• Complies with CLS with the exceptions where non-CLS-compliant Microsoft classes and interfaces are required.

• Was built and testing with Microsoft BizTalk Server 2006 R2