Import Data from MS Excel 2007 or Newer
History | Edit

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. Select --ALL AVAILABLE SITES-- from the drop-down menu.
  3. Select Excel XLSX libraries plugin and click Next.
  4. Select the I accept all terms of the end user license agreement option and click Finish.
  5. 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 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

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