Extracts data from Excel spreadsheets and view them in wiki pages

Description

Representing data in Wiki Tables

Usage

If your data is in an excel file and you want to display it in your wiki page, you can simply attach your excel file to your page and use a code like the following:

Here, the first parameter specifies the name of the Excel attachment. The second parameter specifies the name or number of the sheet where your data is located. The last parameter specifies the range of the data.

Example

Representing data on Charts

This is an extension of the Charting Plugin which allows you to extract your data from your excel files and show them on your wiki pages.

Usage

Since this is an extension of the Charting Plugin, you can use all of the chart types as described in Charting Samples. The only difference is that the source of the chart is specified like the following:

Acknowledgment

The development of this plugin was in part supported by award no. OCI-0724806 from the National Science Foundation.

Prerequisites & Installation Instructions

• Download the Java Excel API and copy the jxl.jar file to the %xwikipath%/WEB-INF/lib/ directory of your xwiki installation.
• Download the plugin on this page and copy the jar file to the %xwikipath%/WEB-INF/lib/ directory of your xwiki installation.

Edit your WEB-INF/xwiki.cfg file as follows:

Restart your XWiki instance

You can try if the installation is good with this code :

You should see as result something like "com.xpn.xwiki.plugin.excel.ExcelPluginAPI@1e36ee47". If not, there is something wrong in your installation.

Example of usage:

Release Notes

v1.1

• XCONTRIB-261: Update parent POM to XWiki Commons 4.5.4
• XCONTRIB-262: Upgrade JExcelApi to version 2.6.12

Dependencies

Dependencies for this extension (org.xwiki.contrib:xwiki-plugin-excel 1.1):

• org.xwiki.platform:xwiki-platform-chart-plugin 4.5.4
• net.sourceforge.jexcelapi:jxl 2.6.12