This plugin isn't bundled with any XWiki product by default.
Plugin contributed by Yasser Ganjisaffar and Cristina Lopes.
This plugin can be downloaded.

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.

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

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

Copy the plugin jar to the %xwikipath%/WEB-INF/lib/ directory of your xwiki installation.

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.

Version 4.2 last modified by ganji on 07/05/2008 at 14:01

Comments 1

ThomasEveilleau | 07.05.2008 at 02:01 PM
There is a problem with this plugin : it generates gigas of logs !

Attachments 0

No attachments for this document

Creator: ganji on 2008/01/29 02:50
This wiki is licensed under a Creative Commons license
1.4.1.10194