List Info

Thread: how to do custom formula functions embedded in the document?




how to do custom formula functions embedded in the document?
user name
2007-07-31 11:10:15
I belive some form of macro would be suitable for this job.
The function has to fetch some xml from a remote url, the
xml has to be parsed and the parameters for the url are
sent as post data (as xml)
I've failed to find apis for doing url fetching in basic.
Python would be suitable for doing that (rich standard
library, good docs) but, again, i've failed to find a way to
use
python functions as formula functions (basic functions
are callable from a formula but, there is no obvious way
to call some python functions from the basic macro)

Any help is apreciated.

-- 
http://ionel.zapto.org
ionel.
Re: how to do custom formula functions embedded in the document?
user name
2007-08-01 00:33:39
Ionel Maries Cristian wrote:
> I belive some form of macro would be suitable for this
job.
> The function has to fetch some xml from a remote url,
the
> xml has to be parsed and the parameters for the url
are
> sent as post data (as xml)
> I've failed to find apis for doing url fetching in
basic.
> Python would be suitable for doing that (rich standard
> library, good docs) but, again, i've failed to find a
way to use
> python functions as formula functions (basic functions
> are callable from a formula but, there is no obvious
way
> to call some python functions from the basic macro)
>
> Any help is apreciated.
>   
Have you looked at any "stock quote" examples with
Calc? They usually 
obtain a document from a URL of some sort and then parse
it.

-- 
Andrew Pitonyak
My Macro Document: http://www.pi
tonyak.org/AndrewMacro.odt
My Book: http://w
ww.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.or
g/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org


[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )