XLSX Adapter

Usage

The XLSX format (since Office 2007) is a zip archive comprising several XML-based configuration and data files.

The XLSX Format Adapter transforms this archive into a single XML structure based on the IBISDirectory-XML format and creates an XLSX zip archive from a file in the IBISDirectory-XML format, respectively.

When converting XLSX > XML no layout information is taken over.

Preparing Input Messages for XML > XLSX Conversion

When converting from XML > XLSX, the XLSX adapter expects input messages to have the IBISDirectory-XML format.

Use an XSLT converter and the supplied mapping template for converting your input message into this format.

Proceed as follows

  1. Create an XSLT converter.

  2. In the XML target file area, click the module guide 932 1 button and select Open from > Repository. The Repository Explorer is displayed.

  3. Open the directory Global > System > Mapping Templates > XLSX Adapter and select the file ExampleFolder.xml

  4. Click OK. The explorer closes and the template is displayed.

  5. Map your input message on the template structure.

    Refer to XSLT Command Wizard in the XSLT Converter

XLSX Adapter Properties Dialog

Base configuration

  • Conversion direction

    Select one of the following:

    • XLSX to IBISDirectory-XML

    • IBISDirectory-XML to XLSX

Press Esc to exit full screen
Modal image placeholder
Press Esc to exit full screen