Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
xls
Active Branch_Dec_11 Website u... 93.7 kB 2 15-Feb-2012 21:55 120.62.163.103
class
ExcelToHTMLPlugin.class 7.7 kB 6 14-Aug-2006 15:34 Candid Dauth
java
ExcelToHTMLPlugin.java 11.4 kB 7 14-Aug-2006 15:34 Candid Dauth
xls
ExcelToHTMLPlugin.xls 15.4 kB 2 20-Dec-2007 12:50 122.164.21.148
class
MPE_ExcelToHTMLPlugin.class 11.2 kB 1 02-Aug-2007 23:54 KarlHansen compiled from MPE_ExcelToHTMLPlugin.java
java
MPE_ExcelToHTMLPlugin.java 14.0 kB 2 11-Jun-2007 17:33 83.145.93.242 Use style instead of bgcolor which is deprecated for Firefox compatibility
xls
MPE_ExcelToHTMLPlugin.xls 26.6 kB 3 10-Jun-2010 19:02 193.247.180.4
jar
jxl.jar 438.2 kB 2 06-Sep-2004 19:35 200.48.230.16

This page (revision-57) was last changed on 21-Sep-2011 19:01 by Jerry Andrews  

This page was created on 01-Dec-2003 23:59 by RichFreedman

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 1 changed one line
ExcelToHTMLPlugin is a WikiPlugin that reads an MS Excel file, and displays it as an HTML table.
ExcelToHTMLPlugin is a WikiPlugin that reads an MS Excel file in the older 2003 format (not xlsx), and displays it as an HTML table.
At line 28 removed 2 lines
[{INSERT ExcelToHTMLPlugin border='1' headerbackgroundcolor='#CC40CC'
headercolor='white' evenrowbackgroundcolor='#EEEEEE' src='ExcelToHTMLPlugin.xls'}]
At line 29 added one line
At line 165 added 83 lines
----
Hello,
Thanks for this useful plugin.
I modified it to add two new parameters :\\
# srcsheet to be able to specify a specific Excel sheet (and not display all sheets as successive table)
# keepformat to be able to keep Original Excel Format. This means that cell background color is recreated, text color is kept, bold and italic are also kept. In addition, to allow more flexibility to display or not empty cell, a cell will have border on the page (even if empty) only if it has borders in Excel. This is also a way to keep cells on the page with no borders.
\\
For the last parameter, to be able to manage the color correctly, I used jxl.jar version 2.6.4 to get access to RGB class.
--[Marc Pelissier|mailto:wild.images@free.fr], 01-Jun-2007
----
Trying to use the keepformat facility.\\
For the benefit of anyone else please note that the acceptable values appear to be 'yes' or 'no' - I tried 1 and 0 to being with.\\
On Firefox 2.0.0.4 cell background colours get lost. It's okay on IE.\\
Cell background colours do work on this Firefox if you set them as a paramater of the plugin as in some of the examples.\\
--Neville Hobson, 07-Jun-2007
----
Hello,
Indeed, I saw afterwards that cell background colors get lost in Firefox (OK in IE).
This was due to the use of a deprecated html array command bgcolor. The new plugin version (java file attached was updated) now use style which is fine with Firefox and IE.
I also updated the Excel Attachement to indicate that keepformat is using yes or no values.
--[Marc Pelissier|mailto:wild.images@free.fr], 11-Jun-2007
----
__Installation Instructions__
I'm glad to see that this plugin has taken on a life of it's own, since I haven't had a chance to work on it in quite a while. Since a lot of people have been asking, though, I thought I'd add installation instructions:
Generally, the installation for this is the same as [any other plugin|InstallingPlugins]:
- put the classes / jar files in the JSPWiki web application's classpath
- edit jspwiki.properties to add the plugin to the plugin search path
Specifically, for this plugin:
- I'm assuming that you will want to use the latest version, which at the moment is [http://www.jspwiki.org/attach/ExcelToHTMLPlugin/MPE_ExcelToHTMLPlugin.java].
- Download the source file by clicking the link above, and put it in it's proper directory -
fr/home/mcm/plugin, and change the file name to ~ExcelToHTMLPlugin.java
- download the jxl.jar file that is attached to this page, and put it in the compiler's classpath ( actually, you'll probably want to get the latest version, [here|http://www.andykhan.com/jexcelapi/download.html] )
- Compile ~ExcelToHTMLPlugin.java, which will result in ~ExcelToHTMLPlugin.class
- put ~ExcelToHTMLPlugin.class in the web application's classpath, i.e. WEB-INF/classes/fr/home/mcm/plugin
- copy the jxl.jar file to the web application's classpath, i.e. WEB-INF/lib
- edit jspwiki.properties, adding or modifying the jspwiki.plugin.searchPath entry to include:
jspwiki.plugin.searchPath = fr.home.mcm.plugin
- remember to restart the JSPWiki application to take advantage of the plugin.
- placement of xls files and syntax for the plugin are at the top of this page.
--RichFreedman, 01-Aug-2007
----
Richard Freedman compiled {{{MPE_ExcelToHTMLPlugin.class}}} for me, and I am attaching it here, as well as the newer jxl.jar (named newer.jxl.jar)
--KarlHansen, 02-Aug-2007
----
Oops, the newer jxl.jar is too large. Follow the link above, instead.
--KarlHansen, 02-Aug-2007
Version Date Modified Size Author Changes ... Change note
57 21-Sep-2011 19:01 11.191 kB Jerry Andrews to previous
56 02-Aug-2007 23:58 11.155 kB KarlHansen to previous | to last
55 02-Aug-2007 23:56 11.135 kB KarlHansen to previous | to last Comment by KarlHansen
54 02-Aug-2007 23:53 11.022 kB KarlHansen to previous | to last Comment by KarlHansen
53 01-Aug-2007 21:50 10.833 kB RichFreedman to previous | to last
52 01-Aug-2007 21:43 10.716 kB RichFreedman to previous | to last
51 01-Aug-2007 21:41 10.711 kB RichFreedman to previous | to last Added Installation Instructions
50 01-Aug-2007 21:20 9.12 kB 204.151.168.29 to previous | to last
49 11-Jun-2007 17:36 9.278 kB Marc Pelissier to previous | to last Comment by Marc Pelissier
48 07-Jun-2007 19:27 8.839 kB Neville Hobson to previous | to last Comment by Neville Hobson
47 01-Jun-2007 11:54 8.422 kB Marc Pelissier to previous | to last Comment by Marc Pelissier
46 04-May-2007 08:38 7.652 kB 192.109.190.88 to previous | to last
45 04-May-2007 08:37 7.77 kB 192.109.190.88 to previous | to last
44 04-May-2007 08:37 7.719 kB 192.109.190.88 to previous | to last
43 12-Apr-2007 22:41 7.65 kB KarlHansen to previous | to last
42 21-Sep-2006 06:15 7.343 kB null to previous | to last
41 19-Sep-2006 00:04 7.183 kB Nascif Abousalh-Neto to previous | to last
« This page (revision-57) was last changed on 21-Sep-2011 19:01 by Jerry Andrews