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:
- 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
. - Unpack
poi-bin-3.10-FINAL-20140208.zip
. - Copy the following
.jar
files in theplugin.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 theeclipse/plugins/com.oxygenxml...
folder, and if you installed it via the dropins ZIP distribution, it is located in theeclipse/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
-