ExcelPlugin

Excel Plugin

A plugin that extracts data from Excel spreadsheets and represents them in wiki pages.

Installation

• Download the Java Excel API and copy the jxl.jar file to the %xwikipath%/WEB-INF/lib/ directory of your xwiki installation.
• Download the Excel Plugin for XWiki and copy the jar file to the %xwikipath%/WEB-INF/lib/ directory of your xwiki installation.

xwiki.plugins=[...],edu.uci.ics.mondego.wiki.plugin.excel.ExcelPlugin

Restart your XWiki instance

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:

$xwiki.ExcelPlugin.getTable($attachname, $sheetname, $range)

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

$xwiki.ExcelPlugin.getTable("sample.xls", "1", "A1-B10")

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:

{chart:
  source=type:excel; file:sample.xls; sheet:1; range:A1-C10|
  type=bar|
  width=700
}

Acknowledgment

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