On Monday 21 Feb 2005 16:32, david_coyle(a)vodafone.ie wrote:
Hi all,
I'm pretty new to the linux (Fedora Core 2) environment and hope that this
question is suitable for this mailing list.
I currently have a program written in C++ which is used to automate
Microsoft Excel by writing out data to the spreadsheet and then updating
about 10 charts based on this data in the spreadsheet. I'm not sure if any
of you are familiar with the Microsoft environment but the program is
developed in Visual Studio 6 and is based on the Microsoft Foundation
Classes. I have Open Office installed on my linux machine and I know it is
possible to open / read / write an Excel file using Open Office Calc and to
create charts manually.
What I'm wondering is if it is possible to automate the process of writing
to and updating the charts in an Excel file in C / C++ code so that it will
work in the same way as the windows program I already have and where could
I get documentation on how to do this. If its not possible to do this with
Excel files (although I would prefer to use Excel files), is it possible
to automate the process using the standard Calc spreadsheet file format,
.sxc and where could I get documentation on how to do this. Alternatively,
would there be any way to port the program I already have on Windows to
linux.
Thanks,
David
I'd figure from your email you are used to writing C/C++.
However, if you are willing to take a dive into Java, then the entire
OpenOffice enviroment is programmable via Java .. so even without knowing
what your problem is, I'm pretty sure you could reprogram your updates into
Java and use the native OO spreadsheets.
Exporting to Excel is then a matter of calling the correct export routine from
inside OO, assuming you still need Excel around at all.
You can download the OpenOffice SDK quite easily. It provides you easy access
to the OO internals. Even quite low down routines can be accessed. The
documentation is not quite good enough yet, and there are very few examples
around, but there's enough to get going with.
We used a similar system in one client's office to program their entire
document flow, including integration into a 3rd party database. I personally
think the Java interface with OO is even more advanced than the available
interfaces to Excel. Once you understand the enviroment, its certainly safer
to program, but then I would say that, I prefer java to C++.
--
Tony Dietrich
-------------
What use is magic if it can't save a unicorn?
-- Peter S. Beagle, "The Last Unicorn"