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 179 added 69 lines
----
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