XLS to XML
Natively Accept an XLS file or Excel Spreadsheet for Conversion Into an XML Format with the eiConsole’s Excel Sheet Converter Processor
The eiConsole and 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.