Import Data from MS Excel 2007 or NewerEdit online
To import spreadsheet data from Excel 2007 or newer (.xlsx), Oxygen XML Editor plugin needs additional libraries from the release 3.10 of the Apache POI project.
Manually Add the Libraries
To manually 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 the
plugin.xml file of the Oxygen XML Editor 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
Result: You can now use the Import wizard to import data from Excel 2007 or newer.