Posted by
Peter Haub on
Jul 01, 2011; 2:09pm
URL: http://imagej.273.s1.nabble.com/Opening-of-RoiSet-files-tp3684044p3684047.html
Dear list,
I have used OpenOffice Calc to automatically create spreadsheets by
ImageJ plugins.
Maybe this code can be useful for somebody out there.
If OpenOffice is installed on your MS Windows systems in the default
path "C:\Program Files\OpenOffice.org 3", then simply copy the complete
folder \ConnectOO to your ImageJ plugins folder, restart ImageJ and
start the plugin 'Test_OpenOSpreadS'.
This demo will open the spreadsheet and insert some numbers, an image
and will create one chart.
(If OpenOffice is installed in a different location the String
'oooExeFolder' has to modified in the 'Test_OpenOSpreadS.java' and the
plugin has to be re-compiled.)
The demo plugin 'Test_OpenOSpreadS' uses the subclass
'OpenOSpreadS.class' which contains the most important functions to
establish the connection between ImageJ and OpenOffice and to manipulate
the spreadsheet tables.
Please have a look into the description in 'OpenOSpreadS.java'.
(For detailed information please refer to the OpenOffice API documentation.)
The connection is not very fast. Therefor it can take some time to
create very complex spreadsheets. Also be a little patient while the
connection will be closed - otherwise you will see some OO-Error messages.
But nevertheless this can be used as a nice reporting tool.
I'm sorry not to be able to test on other OS then Windows.
The files can be found on
https://rapidshare.com/files/954168287/IJ2OO.7zRegards,
Peter