Excel Connector


Convert XML files into custom formatted Excel spreadsheets, and convert Excel spreadsheets into structured XML ready for processing.


The Excel Connector ships with the latest version of ArcESB.

Documentation

The Benefits of Excel

  • Present business data in Microsoft Excel by converting XML data in your workflow into custom formatted Excel spreadsheets with no code or custom scripting required.
  • Pre-configure standard Excel files as templates that define layour and formatting information, which the connector will use to generate new documents.
  • Visualize data from incoming EDI documents such as Health Insurance Claims, Invoices, Purchase Orders, and more in human-readable spreadsheets.
  • Define Excel templates to extract a predefined set of information from Excel spreadsheets to output as XML documents.
  • Translate data to and from a variety of popular formats without writing cumbersome scripts or programs.

Key Features

  • Parse XML documents and generate the new Excel sheets based on easy-to-use Excel templates.
  • Convert Excel spreadsheet data to XML messages for automated data processing.
  • Transform EDI data into human-readable purchase orders, invoices, sales receipts, and more.
  • Supports Microsoft Excel 2007+
  • Configurable Automation Settings.
  • Pre- and Post-Processing Events.
  • and much more...
Documentation

Sorry, this is not a valid link or file is not found.