exist-development

[Exist-development] Apache POI

[Loren C. <lor...@gm...>]

Has anyone integrated Apache POI into eXist to read and write excel spreadsheets?

Re: [Exist-development] Apache POI

[Adam R. <ad...@ex...>]

No, but I have some experience using POI and my question would be -
how the hell would you wrap their complex programmatic API inside
anything else that would be usable? Thats why I always avoided adding
it to eXist-db so far ;-)

On 9 August 2011 20:14, Loren Cahlander <lor...@gm...> wrote:
> Has anyone integrated Apache POI into eXist to read and write excel spreadsheets?
> ------------------------------------------------------------------------------
> uberSVN's rich system and user administration capabilities and model
> configuration take the hassle out of deploying and managing Subversion and
> the tools developers use with it. Learn more about uberSVN and get a free
> download at:  http://p.sf.net/sfu/wandisco-dev2dev
> _______________________________________________
> Exist-development mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-development
>



-- 
Adam Retter

eXist Developer
{ United Kingdom }
ad...@ex...
irc://irc.freenode.net/existdb

Re: [Exist-development] Apache POI

[Loren C. <lor...@gm...>]

I am looking at reading and creating excel files.

Sent from my iPhone

On Aug 9, 2011, at 4:57 PM, Adam Retter <ad...@ex...> wrote:

> No, but I have some experience using POI and my question would be -
> how the hell would you wrap their complex programmatic API inside
> anything else that would be usable? Thats why I always avoided adding
> it to eXist-db so far ;-)
> 
> On 9 August 2011 20:14, Loren Cahlander <lor...@gm...> wrote:
>> Has anyone integrated Apache POI into eXist to read and write excel spreadsheets?
>> ------------------------------------------------------------------------------
>> uberSVN's rich system and user administration capabilities and model
>> configuration take the hassle out of deploying and managing Subversion and
>> the tools developers use with it. Learn more about uberSVN and get a free
>> download at:  http://p.sf.net/sfu/wandisco-dev2dev
>> _______________________________________________
>> Exist-development mailing list
>> Exi...@li...
>> https://lists.sourceforge.net/lists/listinfo/exist-development
>> 
> 
> 
> 
> -- 
> Adam Retter
> 
> eXist Developer
> { United Kingdom }
> ad...@ex...
> irc://irc.freenode.net/existdb

Re: [Exist-development] Apache POI

[Evgeny G. <gaz...@gm...>]

On 09.08.2011 23:14, Loren Cahlander wrote:
> Has anyone integrated Apache POI into eXist to read and write excel spreadsheets?
> ------------------------------------------------------------------------------
> uberSVN's rich system and user administration capabilities and model
> configuration take the hassle out of deploying and managing Subversion and
> the tools developers use with it. Learn more about uberSVN and get a free
> download at:  http://p.sf.net/sfu/wandisco-dev2dev
> _______________________________________________
> Exist-development mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-development
Yes I have.
See example in attachment

--
Evgeny

Re: [Exist-development] Apache POI

[Loren C. <lor...@gm...>]

Hello Evgeny,

Thank you for this.  I will try it.

Loren

On Aug 9, 2011, at 5:44 PM, Evgeny Gazdovsky wrote:

> On 09.08.2011 23:14, Loren Cahlander wrote:
>> Has anyone integrated Apache POI into eXist to read and write excel spreadsheets?
>> ------------------------------------------------------------------------------
>> uberSVN's rich system and user administration capabilities and model
>> configuration take the hassle out of deploying and managing Subversion and
>> the tools developers use with it. Learn more about uberSVN and get a free
>> download at:  http://p.sf.net/sfu/wandisco-dev2dev
>> _______________________________________________
>> Exist-development mailing list
>> Exi...@li...
>> https://lists.sourceforge.net/lists/listinfo/exist-development
> Yes I have.
> See example in attachment
> 
> --
> Evgeny
> <xls2table.xqm>------------------------------------------------------------------------------
> uberSVN's rich system and user administration capabilities and model 
> configuration take the hassle out of deploying and managing Subversion and 
> the tools developers use with it. Learn more about uberSVN and get a free 
> download at:  http://p.sf.net/sfu/wandisco-dev2dev
> _______________________________________________
> Exist-development mailing list
> Exi...@li...
> https://lists.sourceforge.net/lists/listinfo/exist-development

Re: [Exist-development] Apache POI

[Evgeny G. <gaz...@gm...>]

On 10.08.2011 06:35, Loren Cahlander wrote:
> Hello Evgeny,
>
> Thank you for this.  I will try it.
>
> Loren
>
> On Aug 9, 2011, at 5:44 PM, Evgeny Gazdovsky wrote:
>
>> On 09.08.2011 23:14, Loren Cahlander wrote:
>>> Has anyone integrated Apache POI into eXist to read and write excel spreadsheets?
>>> ------------------------------------------------------------------------------
>>> uberSVN's rich system and user administration capabilities and model
>>> configuration take the hassle out of deploying and managing Subversion and
>>> the tools developers use with it. Learn more about uberSVN and get a free
>>> download at:  http://p.sf.net/sfu/wandisco-dev2dev
>>> _______________________________________________
>>> Exist-development mailing list
>>> Exi...@li...
>>> https://lists.sourceforge.net/lists/listinfo/exist-development
>> Yes I have.
>> See example in attachment
>>
>>

Sorry, I'd forgot the small java class.
See attachment.
There is a listener, that convert POI events into a sequence of the POI 
records.

You will need to compile class and make a jar or use attached 
hsf-common-listener.jar.
Then put one into $EXIST_HOME/lib/user with POI jars.
I use next jars: poi-scratchpad-*.jar, poi-ooxml-*.jar, 
poi-contrib-*.jar, poi.
* is POI version

--
Evgeny