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. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

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).


Updated March 18, 2021