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


Am 21.08.2017 um 21:59 schrieb David Vittor <dvit...@gmail.com>:

Great work Dave,

I can see it here: https://blogs.apache.org/jspwiki/

Thanks,
David V


On Mon, Aug 21, 2017 at 4:48 AM, Juan Pablo Santos Rodríguez <
juanpablo.san...@gmail.com> wrote:

+1

tx!

El 19 ago. 2017 11:04 a. m., "Dave Koelmeyer" <
dave.koelme...@davekoelmeyer.co.nz> escribió:


*********************

Presenting the content of Microsoft Excel spreadsheets in JSPWiki is
possible by using the Worksheet plugin—developed by Christian Fröhler.
Installation is straightforward, consisting of adding a few extra Java
libraries to your application server and the plugin itself. After a
restart, add some simple JSPWiki markup to display the content of an
attached Excel document:

Even better, the content can be styled with JSPWiki's wide range of
styles.
For more information please see the Worksheet Plugin page. Development
contributions to enhance and improve the plugin are welcome!

*********************

--
Dave Koelmeyer
http://blog.davekoelmeyer.co.nz
GPG Key ID: 0x238BFF87




Reply via email to