Is it possible to make a live spreadsheet, meaning that the content of the
cells are provided by a live XML feed from an APi. The idea is to have
stock charts/currency exchange/ and/or pricing of products directly
inserted into a Calc spreadsheet and users can add calculation to this
live objects such as graph a yield or update their price to their local
currency automatically.
Internet -- XML Feed --- OOoMacro -- Live Spread Sheet
My first question will be if the XML can be register as a DataSource,
which protocol to use so OOo can identify it as a datasource, second will
be how to use the XML parser that OOo includes (SAX?) from the Macro API
and finally can this connection be mantain as permanent or should it be
required every x seconds.
First idea is that hdbsql is close to this question because of its native
XML method of storage. OOo should at some point parse the information to
be included into the widgetery.
The parser should be available somewher around the com.sun.star.xml and
the registry could be on a fetch array function within the scripting
framework to finally be inserted into a cell.
Am I ignoring something I should also be aware? Any answer to the previous
doubts about best way to connect and parse?
--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
