The svn repository moved some time ago to osgeo hardware:
- http://svn.osgeo.org/geotools/trunk/modules/unsupported/excel/
GeoTools and GeoServer in general get along very well together so installation
would stay simple; Ian Turton also expressed interest in the Excel plugin and
may be able to introduce you to the code?
I have not personally looked at the Excel plugin; my understanding is it
implements a DataStore for accessing Excel files. There are a couple tutorials
here with respect to making a datastore
(http://docs.geotools.org/latest/userguide/tutorial/advanced/index.html);
although I suspect it may be easier just to review the excel plugin and ask
questions on geotools-devel.
--
Jody Garnett
On Monday, 9 May 2011 at 5:26 AM, Shane StClair wrote:
> 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/
>
>
> 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 <ijtur...@gmail.com> wrote:
> > On 7 May 2011 19:44, Jody Garnett <jody.garn...@gmail.com> 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
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
