Did you do this on a Mac machine? I figured out how to write the code itself, the problem is getting it to run on a mac machine so I can test it.
Thanks, Tracie On 12/6/06 5:49 PM, "Alexandro Colorado" <[EMAIL PROTECTED]> wrote: > 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. > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
