XLS to XML

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.

Excel Sheet Converter Processor Add Processor Panel

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.

Excel Sheet Converter Processor Configuration Panel

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

Excel Sheet Converter Processor Advanced Panel

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

TAKE A TOUR

PROCESSOR NEXT STAGE >> MD5 HASHING

NEXT STAGE >> XML VALIDATION

This is a unique website which will require a more modern browser to work! Please upgrade today!