Import Data from MS Excel 2007 or Newer

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

   • 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