Table of Contents

Search

  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. XMap
  7. Libraries
  8. Schema Object
  9. Command Line Interface
  10. Scripts
  11. Parsers
  12. Script Ports
  13. Document Processors
  14. Formats
  15. Data Holders
  16. Anchors
  17. Transformers
  18. Actions
  19. Serializers
  20. Mappers
  21. Locators, Keys, and Indexing
  22. Streamers
  23. Validators, Notifications, and Failure Handling
  24. Validation Rules
  25. Custom Script Components

Data Transformation User Guide

Data Transformation User Guide

XmlToExcel

XmlToExcel

The
XmlToExcel
document processor converts XML documents to Microsoft Excel format.
The processor operates on an XML representation of an Excel workbook. The XML representation must be in the UTF-8 encoding and it must conform to the
ExcelToXml.xsd
schema. You can find the schema in the
doc
subdirectory of the installation directory. The schema file is provided for your information. You can use the processor without adding the schema to your project.
The processor reverses the operation of
ExcelToXml
. For example, you can use
ExcelToXml
to convert an Excel workbook to XML. You can then alter some of the XML data and use
XmlToExcel
to convert the data back to an Excel workbook.
This component supports Excel version 97 and higher. It writes its output directly, not through Microsoft Excel. You do not need to install Excel on the computer.
This component is implemented in Java and requires correct configuration of the Java Runtime Environment (JRE).