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/WorksheetPlugin-required-libs-0.6.zip(info)

Usage#

  • Additional step when upgrading von Worksheet Plugin 0.5 to 0.6: Delete the following files from your <tomcat>/webapps/JSPWiki/WEB-INF/lib directory:
    curvesapi-1.03.jar poi-3.14.jar poi-examples-3.14.jar poi-ooxml-3.14.jar poi-ooxml-schemas-3.14.jar poi-scratchpad-3.14.jar
  • Download the WorksheetPlugin-required-libs-0.6.zip file, and extract into your <tomcat>/webapps/JSPWiki/WEB-INF/lib directory
  • Place the jar file into your <tomcatDir>/webapps/JSPWiki/WEB-INF/lib/ directory (see download links below)
  • Restart your tomcat
  • Attach an Excel document to your page and add the following JSPWiki source:
%%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)
  • fixed two issues from github tracker
    • "%n" string when the plugin is inserted #1
    • dependencies.jar contains hidden __MACOSX folder #2
v0.4-alpha (25-Mar-2016)
  • for JSPWiki 2.10+.
  • Uses POI's "ToHtml" example class to output the html table; including .css formatting
v0.4-284alpha (25-Mar-2016)
  • for JSPWiki 2.8.2+.
  • Uses POI's "ToHtml" example class to output the html table; including .css formatting


Category.Plugins