Thanks Roy,

 It is also possible to configure excel to pull the data from the server at regular time.
 Also, it is possible to remove columns, and so far the removed columns do not re-appear when refreshed.

 So with this method it is easy to 'view' eXist data as a XML result of a xquery.

 Now, is there a way to connect the other way around, where excel can be used to edit and save data in the eXist database ? (it is possible with other databases)

 Regards
-- Remi

On Thu, Oct 28, 2010 at 2:16 PM, Roy Walter <garliestonhouse@yahoo.co.uk> wrote:
Well I tried this just for fun. I opted for a web query via REST and tried the following [quick] tests:
http://server:8008/exist/rest/db
This is the db 'root' and returns a well formatted 10 column spreadsheet from the source XML. Excel also creates a schema. I then tried an XQuery file that returns XML and it works fine too.

I suppose that none of this is particularly surprising since Excel (and other MS Office products) are all XML aware these days.

-- Roy


On 28/10/2010 21:38, Rémi Arnaud wrote:
Sorry I messed up another thread. Resending with new title.

Regards
-- Remi

On Tue, Oct 26, 2010 at 5:58 PM, Rémi Arnaud <jsremi@gmail.com> wrote:
Sorry I was not more clear.

Excel offers data connection (to external database system). Please see attached picture.

There are several methods.
The 'from web' seems interesting as this could be using a html page returned by a xquery ?

I do not know there is a BKM to connect eXist to excel through any of those data connectors ?
The documentation seems to indicate there is some kind of REST API that excel is using to communicate with sharepoint to load/save spreadsheet.

I was wondering if someone had some success to connect eXist to excel through one of those data connection mechanism.

Regards
-- Remi



On Tue, Oct 26, 2010 at 2:09 PM, Adam Retter <adam@exist-db.org> wrote:

Sorry I am not clear on what you are trying to achieve. Are you trying to get data in or out of excel?

On 26 Oct 2010 21:33, "Rémi Arnaud" <jsremi@gmail.com> wrote:
>>Is there a REST style API that can be used ? yes
>
> I have been using exist/rest as well as xquery scripts, but I did not see existing scripts or how to use the eXist built-in rest API to provide an interface with excel data connection. Is there more information available about this?
>
> Regards
> - Remi
>
>
>
> -----Original Message-----
> From: Dannes Wessels <dannes@exist-db.org>
> Sender: Dannes Wessels <dizzzz@exist-db.org>
> Date: Tue, 26 Oct 2010 21:49:32
> To: Rémi Arnaud<remi@acm.org>
> Cc: exist-open@lists.sourceforge.net<exist-open@lists.sourceforge.net>
> Subject: Re: [Exist-open] base-uri()/document-uri() in XSLT 2.0
>
>
> On 26 Oct 2010, at 20:18 , Rémi Arnaud wrote:
>
>> Is there a ODBC driver that can be installed to connect Excel to the eXist server?
>
> no, ODBC usage is limited to relation databases, it does not fit other kind of databases
>
>> Is there a REST style API that can be used ?
>
> yes
>
>> PS: I did not find how to search the exist-open archives from this interface: http://sourceforge.net/mailarchive/forum.php?forum_name=exist-open
>
> on the portal page http://www.exist-db.org/ there are better alternatives linked at MarkMail and gmane.....
>
>
> Kind regards
>
> Dannes
>
> --
> eXist-db Native XML Database - http://exist-db.org
> Join us on linked-in: http://www.linkedin.com/groups?gid=35624
>
>
>
>
>
>
>
>
>



--
Rémi Arnaud



--
Rémi Arnaud
------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________ Exist-open mailing list Exist-open@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/exist-open



--
Rémi Arnaud