Message-ID: <6731304c0712140619q545c7b82l44e0b4a05c3b5eae@mail.gmail.com>
Date: 2007-12-14T14:19:24Z
From: Max Kuhn
Subject: RJDBC to OpenOffice Calc as RODBC to MS Excel
In-Reply-To: <1197638903.3134.16.camel@Bellerophon.localdomain>
On Dec 14, 2007 8:28 AM, Marc Schwartz <marc_schwartz at comcast.net> wrote:
>
> Bearing in mind that OO.org's Write and Calc documents are just 'zipped'
> XML files, it would be possible to parse the data stored within such
> documents. I suspect Max Kuhn has spent much time on this for odfWeave.
>
I haven't played much with Calc, but it if the Calc file has formulas
or anything other than raw data, this would probably be a mess to
parse.
The first thing that I would try is to use command line tools (like
ooconvert or jodconverter) to convert the file to csv and then read it
in. These tools were written for Write documents, but they may also be
good at converting other types of od* documents.
Good luck,
Max