Hi, thanks for promoting the plugin. We are using it quite heavily, because it makes the maintenance of large tables easier. I have enhanced the plugin a bit, and have released version 0.6. Now column widths are taken correctly from the excel sheet. Unfortunately JSPWiki won’t let me update the wiki page: Your edit has been rejected by our SpamFilter, sorry.Could someone please update the wiki page? Content attached. |
[{TableOfContents}] \\ 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|JSPWikiStyle] like {{{%%table-filter}}} can be applied to the output. The plugin uses [Apache POI|https://poi.apache.org/], 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|WorksheetPlugin/WorksheetPlugin-0.6.jar] for JSPWiki 2.10+ \\ [WorksheetPlugin-0.6-284.jar|WorksheetPlugin/WorksheetPlugin-0.6-284.jar] for JSPWiki 2.8 || Dependencies | [WorksheetPlugin-required-libs-0.5.zip|WorksheetPlugin/WorksheetPlugin-required-libs-0.6.zip] !!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)__ * [issue #3|https://github.com/generatorr/WorksheetPlugin/issues/3|target='_blank'] 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=61454] for details __v0.5 (for JSPWiki 2.10+), v0.5-284 (for JSPWiki 2.8) (29-Mar-2016)__ * fixed two issues from [github tracker|https://github.com/generatorr/WorksheetPlugin/issues?q=is%3Aissue+is%3Aclosed] ** "%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 !! Links * [Source repository @ github|https://github.com/generatorr/WorksheetPlugin] * [Older releases of WorksheetPlugin|https://github.com/generatorr/WorksheetPlugin/releases] [{PageViewPlugin}] ---- [Category.Plugins]
And - I have lost my password for JSPWiki; the „lost password“ page didn’t send email to my account (yes, I have checked all spam folders etc.) Therefore I created a 2nd account. Cheers Christian
|