Import Data from MS Excel 2007 or Newer

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 the additional 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

Parent topic: Import from MS Excel Files