Where minds and technology meet.
Search Site GrapeCity Portal Home
A pipeline assembler and disassembler that creates and parses Microsoft Excel® data in BizTalk Applications
 »Spread for BizTalk Server » Product Features

FarPoint Spread for BizTalk Server Product Features

This latest release of FarPoint Spread for BizTalk has been tested and is fully compatible with Microsoft BizTalk® Server 2006/2009. FarPoint Spread for BizTalk version 3.0 includes an Assembler and Disassembler that supports Office 2007 XML format, also known as Microsoft Office Open XML (OOXML), Microsoft Excel® workbooks with a variable numbers of sheets to validate against a single schema (for applications that receive Excel files with variable number of sheets of a common format) and the ability to open password-protected files.

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 2008/2005
  • Complies with CLS with the exceptions where non-CLS-compliant Microsoft classes and interfaces are required
  • Allows the parsing of password-protected Excel documents by setting the password to the component

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 2008/2005
  • Complies with CLS with the exceptions where non-CLS-compliant Microsoft classes and interfaces are required.
  • Allows the creation of password-protected Excel documents by setting the password to the component