Table of Contents
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 POIContent unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png, 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/WorksheetPluginContent unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png |
| Issues | https://github.com/generatorr/WorksheetPlugin/issuesContent unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png |
| Plugin | WorksheetPlugin-0.6.jarContent unavailable! (broken link)(info) for JSPWiki 2.10+ WorksheetPlugin-0.6-284.jarContent unavailable! (broken link)(info) for JSPWiki 2.8 |
| Dependencies | WorksheetPlugin/WorksheetPlugin-required-libs-0.6.zipContent unavailable! (broken link)(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/aRelease History#
v0.6 (for JSPWiki 2.10+), v0.6-284 (for JSPWiki 2.8) (25-Aug-2017)- issue #3Content unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png Long content in table cells breaks layout
- upgrade to Apache POI 3.16
- contains a patched version of poi-examples-3.16.jar
- see https://bz.apache.org/bugzilla/show_bug.cgi?id=61454Content unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png for details
- fixed two issues from github trackerContent unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png
- "%n" string when the plugin is inserted #1
- dependencies.jar contains hidden __MACOSX folder #2
- for JSPWiki 2.10+.
- Uses POI's "ToHtml" example class to output the html table; including .css formatting
- for JSPWiki 2.8.2+.
- Uses POI's "ToHtml" example class to output the html table; including .css formatting
Links#
- Source repository @ githubContent unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png
- Older releases of WorksheetPluginContent unavailable! (broken link)https://jspwiki-wiki.apache.org/images/out.png
Category.Plugins
