• B2B ADAPTERS - PROCESSORS
• Transaction Attributes
• Key Encryption
• B2B Authentication
• Charset Conversion
• EBCDIC to ASCII
• Base64 Encoder
• Chained Transactions
• Data Attribute Swapper
• Zip / Unzip
• XLS to XML
• MD5 Hashing
• Java XML Binding
• MIME Decoder
• MIME Encoder
• MTOM
• TIFF to XML
• Remove Namespaces
• Regex Evaluation
• Add SOAP Header
• Symmetric Encryption
• XML Logging
• XML Validation Rules
• WS-Security
• XML to PDF
• XPath Evaluation

XLS to XML

Natively Accept an XLS file or Excel Spreadsheet for Conversion Into an XML Format with the XCS eiConsole's Excel Sheet Converter Processor

The XCS eiConsole and XCS eiPlatform have the native capability to accept an XLS file or Excel spreadsheet for conversion into an XML format. As with all the components of the eiConsole the user is presented with a graphical interface with easy to configure panels. The Excel Sheet Converter Processor provides two ways to do this. First, you can use the Excel Sheet Conversion Processor. Choose this option from the Add Processors menu.

Name the Processor: ConvertXLSToXML and hit Add.

On the Basic tab you will see a Sheet Index configuration item. This asks you to provide the Excel worksheet that you wish to convert into XML. By default this is 0 – which would be the first sheet.

On the Advanced tab you can choose to enter a custom Column or Row Delimiter.

The output of this Processor will be an XML based representation of the Excel file that was converted.