Hi,
I actually completed and submitted the changes to the GeoServer Excel output
format plugin. You can see the code here:
http://svn.codehaus.org/geoserver/trunk/src/extension/excel/src/main/java/org/geoserver/wfs/response/
<http://svn.codehaus.org/geoserver/trunk/src/extension/excel/src/main/java/org/geoserver/wfs/response/>The
code uses a text building workaround suggested by Yegor Kozlov of Apache
POI for writing Excel 2007 .xlsx files because writing large files using the
object model uses huge amounts of memory, but the code is designed so that
the overriding methods for this fix can be removed later if performance
improves and the code will revert back to using the POI usermodel.
I'd be happy to collaborate on this and proceed as you suggest (move
functionality to GT and have the GS plugin utilize those classes), as long
as two concerns are satisfied:
1. The installation process for a GeoServer end user should stay simple. I
suppose that even if you had to install a GT plugin along with the GS
plugin, the GT plugin jar would be packaged in the zip file as a dependency
so it would be no different.
2. I'd prefer not to throw away the code I just finished! I don't yet have
any understanding of how GeoTools is structured and how the input/output
plugins fit into the architecture, but I imagine that much of the existing
GS Excel writing code could be moved to GT without too much trouble...
Also, I looked for the Excel plugin in the GT SVN but couldn't find it:
http://svn.geotools.org/trunk/modules/plugin/
http://svn.geotools.org/trunk/modules/unsupported/
Is it still in the SVN somewhere?
Thanks,
Shane
On Sun, May 8, 2011 at 10:10 AM, Ian Turton <[email protected]> wrote:
> On 7 May 2011 19:44, Jody Garnett <[email protected]> wrote:
> > Quick question; the excel plugin was mentioned recently on the geoserver
> > (http://jira.codehaus.org/browse/GEOS-4461) list by Shane.
> > Shane we we considering dropping things from GeoTools unsupported that do
> > not have a friend.
> > Perhaps you would consider becoming co-module maintainer with Ian Turton
> > (who also expressed an interest).
>
> Actually there are two excel modules one in GT to read in excel files
> (that I wrote a while back) and one in GS which writes out excel files
> (that Shane was interested in) but it would be cool if we could
> refactor the GS one to make use of the GT code and add writing to the
> GT code.
>
> Shane - let me know if that seems like a plan to you, and I'll look at
> writing up a GS proposal.
>
> Ian
> --
> Ian Turton
>
--
Shane StClair
Software Engineer
Axiom Consulting & Design
523 W 8th Ave
Suite 104
Anchorage, AK 99501
http://www.axiomalaska.com
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
