Excel Port


The Excel ports can be used to convert data in XML format into a custom formatted Excel spreadsheet, and to convert Excel spreadsheet data into XML for processing.




Excel Connector

Excel spreadsheets are the preferred tool for data presentation for many business users. The Excel ports can be used to convert data in XML format into a custom formatted Excel spreadsheet, and to convert Excel spreadsheet data into XML for processing.

Excel generation is extremely easy to setup and configure. Users pre-configure a standard Excel file as a template that defines layout and formatting information. The Excel port then processes incoming XML and maps that data to output Excel documents. This powerful feature makes it easy to automate the transformation of EDI documents and messages into professional looking human-readable invoices, purchase orders, sales receipts, etc.

Excel to XML processing is similarly straightforward. The Excel port can be configured to monitor an incoming directory for Excel files. When a new Excel file is moved to the incoming directory, the Excel port will extract a predefined set of information from the Excel spreadsheet and output XML.

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.
  • An easy way to transform EDI data into human-readable purchase orders, invoices, sales receipts, etc.
  • Supports Microsoft Excel 2007+



 

The Excel Port ships with the latest version of RSSBus Connect.     

Download Now

Downloads