Import Data from MS Excel 2007 or Newer

To import spreadsheet data from Excel 2007 or newer (.xlsx), Oxygen XML Developer 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 http://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 in the lib directory of the installation folder of Oxygen XML Developer :

    • 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

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