Import Data from MS Excel 2007 or Newer
Edit online

To import spreadsheet data from Excel 2007 or newer (.xlsx), Oxygen XML Editor needs additional libraries from the release 3.10 of the Apache POI project.

To add this support, follow this procedure:
  1. Go to Help > Install new add-ons to open an add-on selection dialog box.
  2. Enter or paste https://www.oxygenxml.com/InstData/Addons/default/updateSite.xml in the Show add-ons from field or select it from the drop-down menu.
  3. Select Excel XLSX libraries plugin and click Next.
  4. Restart the application.

    Result: You can now use the Import wizard to import data from Excel 2007 or newer.

Alternate Method to Manually Add the Libraries

To manually add the libraries, follow these steps:
  1. Download version 3.10 of the Apache POI project from http://archive.apache.org/dist/poi/release/bin/. The specific ZIP file that you need is: poi-bin-3.10-FINAL-20140208.zip.
  2. Unpack poi-bin-3.10-FINAL-20140208.zip.
  3. Copy the following .jar files into the lib directory of the installation folder of Oxygen XML Editor :
    • dom4j-1.6.1.jar
    • poi-ooxml-3.10-FINAL-20140208.jar
    • poi-ooxml-schemas-3.10-FINAL-20140208.jar
    • xmlbeans-2.3.0.jar
      Note: The .jar files can be found in either the root folder where you unpacked the archive, or in the ooxml-lib subfolder.

Result: You can now use the Import wizard to import data from Excel 2007 or newer.