WorksheetPlugin


See ContributedPlugins

Overview#

WorksheetPlugin reads an Excel worksheet, stored as an attachment, and presents its content as a Table.

An Excel workbook typically contains several sheets; the WorksheetPlugin presents one of the sheets.

JSP Wiki Styles like %%table-filter can be applied to the output.

The plugin uses Apache POI, a library that offers access to Microsoft Office documents using the Java programming language.

Written by Christian Fröhler
Date 25-Aug-2017
Plugin Version 0.6 (for JSPWiki 2.10) ; 0.6-284 (for JSPWiki 2.8)
Wiki Versions 2.8+; 2.10+
Demo n/a
Source https://github.com/generatorr/WorksheetPlugin
Issues https://github.com/generatorr/WorksheetPlugin/issues
Plugin WorksheetPlugin-0.6.jar(info) for JSPWiki 2.10+
WorksheetPlugin-0.6-284.jar(info) for JSPWiki 2.8
Dependencies WorksheetPlugin-required-libs-0.5.zip(info)

Usage#

%%zebra-table
%%table-filter
[{WorksheetPlugin src='MyExcelExample.xlsx' sheetName='Sheet1' }]
/%
/%

Parameters#

Param Description Default
src Name of the attached excel document (mandatory)
sheetId ID of the worksheet within the excel document (first sheet has sheetId = 0) if both sheetName and sheetId are omitted, the first sheet in the workbook is taken
sheetName Name of the worksheet within the excel document if both sheetName and sheetId are there, sheetId wins

Properties#

n/a

Release History#

v0.6 (for JSPWiki 2.10+), v0.6-284 (for JSPWiki 2.8) (25-Aug-2017) v0.5 (for JSPWiki 2.10+), v0.5-284 (for JSPWiki 2.8) (29-Mar-2016) v0.4-alpha (25-Mar-2016) v0.4-284alpha (25-Mar-2016)


Category.Plugins