On Wed, 06 Dec 2006 16:22:40 -0600, Tracie Hong <[EMAIL PROTECTED]>
wrote:
Hi all,
I've begun to use my mac quite a bit more than my desktop for
development,
and I now need to create a program that will open a csv file within
OpenOffice Calc, generate a few graphs, and save this spreadsheet. I've
gone
through all the forum posts and other mailing lists, but I can't seem to
find any information on how to use the OpenOffice SDK with a mac. I want
to
write my program using NetBeans 5.0, and can't find any jar files to
include
that would give me access to the OpenOffice API, or anything.
If someone could point me in the right direction, I would really
appreciate
it. I've posted this on the forums as well, but have yet to receive a
reply.
Thanks,
Tracie
------ End of Forwarded Message
I recently did a Python excercise that does exactly that, go to a website
(yahoo finance) get a stock with their price and everything and extract it
as CSV, then it will call on calc and will inser tthe contnent on each
cell and it will refresh every 10 seconds, this made a dynamic spreadsheet
with real time data.
So I am aware that you dont need all that but it will definetly help you
out figure out most of the functionality. Then they went into componetize
the service so you could get it without having to broadcast openoffice.org
as a service.
Here is the code: http://pastebin.mozilla.org/1824
To componetize the code need to be changed like the following:
http://pastebin.mozilla.org/1826
and the XML need it to be labeled as an Addon.xcu:
http://pastebin.mozilla.org/1827
The code could benefit from the csv module to parse the information as
well as uno, as for loading the document that could be done manually. I
dont know much about java so I wouldn't know how to do the pieces for call
on things but the UNO part might call the same components in order to
write things in it.
Hope it helps.
--
Alexandro Colorado
Grupo de Usuarios Linux Tabasco
http://www.gultab.org
OpenOffice.org
Community Contact // Mexico
http://www.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
