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

User Guide

User Guide

ExcelToDataXml

ExcelToDataXml

The
ExcelToDataXml
document processor converts Microsoft Excel documents to XML.
The following table describes the properties of the
ExcelToDataXml
document processor:
Property
Description
enabled
Determines the content of the output. The
enabled
property has the following options:
  • Selected. The output contains raw data and formatted data.
  • Cleared. The output contains only formatted data.
Default is selected.
param1
Determines whether raw data appears in the output of the document processor when the raw data differs from the formatted data.
param1
is named
Display_raw_data_when_different
and has only one property,
enabled
.
param2
Determines whether to add elements to the output when a source table contains empty cells in the middle of a row or rows. For example:
A source table includes three columns and two rows. In the first row, the three columns are populated. In the second row, the first and last columns are populated and the second column is empty.
When param2 is disabled, the processor creates two elements for the second row with the values of the two populated column cells.
When param2 is enabled, the processor creates three elements for the second row: two elements with the values of the populated column cells and one empty element for the empty column cell.
Default is disabled.
param3
Determines whether to add elements to the output when a source table contains empty cells at the end of a row or rows. For example:
A source table includes three columns and two rows. In the first row, the three columns are populated. In the second row, the first column is populated and the second and third columns are empty.
When param3 is disabled, the processor creates one element for the second row, with the value of the populated column cell.
When param3 is enabled, the processor creates three elements for the second row: one element with the value of the populated column cell and two empty elements for the two empty column cells.
Default is disabled.
The XML contains the data and the results of formulas that existed in the original Excel document. It does not preserve the formulas themselves, formatting information, or macro code. If you need to use macro code, use
ExcelToXml
rather than
ExcelToDataXml
.
The XML representation conforms to a subset of the
ExcelToXml.xsd
schema, which you can find in the
doc
subdirectory of the installation directory.
The processor output is in the UTF-8 encoding. If a transformation receives input from the processor, you must set the input encoding to UTF-8.
The processor supports Excel version 97 and later. It accesses its input directly, not through the Excel application. You do not need to install Excel on the computer. The processor supports both the XLS format and the XLSX format.
This component is implemented in Java and requires correct configuration of the Java Runtime Environment (JRE).