Import Data from MS Excel 2007 or Newer

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

To 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 plugin.xml file of the Oxygen XML Developer plugin Eclipse plugin (if you installed the plugin via the Eclipse update site, you will find it in the eclipse/plugins/com.oxygenxml... folder, and if you installed it via the dropins ZIP distribution, it is located in the eclipse/dropins/plugins/com.oxygenxml... folder):
    • 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

Was this helpful?