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