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

ExcelToXml

ExcelToXml

The
ExcelToXml
document processor converts Microsoft Excel documents to XML.
The following table describes the properties of the
ExcelToXml
document processor:
Property
Description
enabled
Defines the value of
param2
or
param3
.
param1
Defines the sheets of the Excel workbook to include in the XML. In the XML output, each sheet is represented by a <sheet> element.
param1
is named
include_sheets
and has the property
value
.
param2
Determines whether the document processor includes empty cells in the output XML if the cells are formatted or merged.
param2
is named
include_empty_cells
and has the property
enabled
, which has the following options:
  • Selected. The output includes empty cells.
  • Cleared. The output omits empty cells.
Default is selected.
param3
Determines whether the document processor includes Excel macro code in the output XML.
param3
is named
include_macro_information
and has the property
enabled
, which has the following options:
  • Selected. The document processor includes macro code.
  • Cleared. The document processor omits macro code.
Default is cleared.
param4
Determines whether the document processor includes unformatted empty cells in the output XML for cells.
param4
is named
include_empty_non_formatted_cells
and has the property
enabled
, which has the following options:
  • Selected. The output includes empty cells.
  • Cleared. The output omits empty cells.
Default is cleared.
value
Defines a list of the following options:
  • The string "All". The output includes all sheets.
  • Data holders containing the sheet names. The output includes only the named sheets.
If you list a sheet that does not exist in the workbook, the processor generates a
<sheet>
element containing a warning message. The other sheets are processed normally. Default is All.
The XML preserves the data, formulas, formatting, and macro code that existed in the original Excel document. If only the data is required, use the
ExcelToDataXml
processor, which offers smaller output and better performance.
The XML representation conforms to the
ExcelToXml.xsd
schema, which is 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-2003. The processor accesses input directly, not through 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