write to Excell specific cell ?
Locked
 
|
Hi,
I am very new to ImageJ, esp. new to Macro coding. I found this is the best forum to get help. Currently I am doing Pathology related image measurement. After getting number from ImageJ Result and calculation, I hope to write the result to Excell cell interactively by Macro coding. e.g. computer pops up message:"Where to write ?", I input C5, then write the value to Excell C5 cell. Next time, I may input D5, then write to D5. I wonder any possible to implement this in Macro, and how ? Thank you very much for your help ! Chengxin |
|
Hi Chengxin,
What you want is Dynamic Data Exchange. Unfortunately, I know of no free DDE library for Java. (There is DDE for Java, and JavaDDE, but both are commercial products.) Maybe someone else knows of a free Java DDE library. For my applications, I have been content to generate tab-delineated text documents that can be easily imported into a spreadsheet. Or generate XLS files using Apache POI. -Curtis On Wed, Feb 27, 2008 at 8:17 AM, Chengxin Li <[hidden email]> wrote: > Hi, > > I am very new to ImageJ, esp. new to Macro coding. I found this is the > best forum to get help. > > Currently I am doing Pathology related image measurement. After getting > number from ImageJ Result and calculation, I hope to write the result to > Excell cell interactively by Macro coding. e.g. computer pops up > message:"Where to write ?", I input C5, then write the value to Excell C5 > cell. Next time, I may input D5, then write to D5. I wonder any possible to > implement this in Macro, and how ? > > Thank you very much for your help ! > > Chengxin > |
Re: write to Excell specific cell ?
|
|
In reply to this post by Chengxin Li
I don't know about writing to a single cell, but you might take a look at
Kurt De Vos's very nice Excel Writer plugin if you haven't already: http://rsbweb.nih.gov/ij/plugins/excel-writer.html Rob -------------- Hi, I am very new to ImageJ, esp. new to Macro coding. I found this is the best forum to get help. Currently I am doing Pathology related image measurement. After getting number from ImageJ Result and calculation, I hope to write the result to Excell cell interactively by Macro coding. e.g. computer pops up message:"Where to write ?", I input C5, then write the value to Excell C5 cell. Next time, I may input D5, then write to D5. I wonder any possible to implement this in Macro, and how ? Thank you very much for your help ! Chengxin |
Re: write to Excell specific cell ?
|
|
In reply to this post by Chengxin Li
Thanks all for the replies. I will try further investigation, e.g. to see the excel-writer codes for any hint.
Thanks again ! Chengxin >>> Robert Baer <[hidden email]> 02/27/08 4:50 PM >>> I don't know about writing to a single cell, but you might take a look at Kurt De Vos's very nice Excel Writer plugin if you haven't already: http://rsbweb.nih.gov/ij/plugins/excel-writer.html Rob -------------- Hi, I am very new to ImageJ, esp. new to Macro coding. I found this is the best forum to get help. Currently I am doing Pathology related image measurement. After getting number from ImageJ Result and calculation, I hope to write the result to Excell cell interactively by Macro coding. e.g. computer pops up message:"Where to write ?", I input C5, then write the value to Excell C5 cell. Next time, I may input D5, then write to D5. I wonder any possible to implement this in Macro, and how ? Thank you very much for your help ! Chengxin |
|
|
In reply to this post by Chengxin Li
P.S.
Chengxin, my idea would require using JAVA to access the Open Office package to write a plugin rather than using the ImageJ macro language. Depending on your experience this might be intimidating, but there is good documentation for writing ImageJ plugins and using the Open Office package is a matter of using their well documented classes so it shouldn't be too bad if you know a little JAVA DOug Chengxin, just an idea . . . I haven't used this package yet but Sun's java IDE NetBeans has recently added integration with an open source package called OpenOffice OpenOffice is essentially a JAVA version of MicroSoft's Office, but its free and open source 8-) It can right EXCEL files as well as its own format: http://www.openoffice.org/ SUN has supported it as an open source package that helps JAVA itself become more powerful Their NetBeans JAVA IDE has a plugin or addon that makes working with OpenOffice easier http://www.netbeans.org/community/magazine/html/03/openoffice/ http://wiki.services.openoffice.org/wiki/OpenOffice_NetBeans_Integration I think its well documented You can do it with other IDEs I'm sure but it may require a little more experience with JAVA packages so it depends on your experience level and how attached you are to a non-NetBeans IDE Good Luck with it . . . I'd like to say I could help more but probably won't be using OPenOffice for a number of months now Doug Chengxin Li wrote: > Hi, > > I am very new to ImageJ, esp. new to Macro coding. I found this is the best forum to get help. > > Currently I am doing Pathology related image measurement. After getting number from ImageJ Result and calculation, I hope to write the result to Excell cell interactively by Macro coding. e.g. computer pops up message:"Where to write ?", I input C5, then write the value to Excell C5 cell. Next time, I may input D5, then write to D5. I wonder any possible to implement this in Macro, and how ? > > Thank you very much for your help ! > > Chengxin > > |
Re: write to Excell specific cell ?
|
|
In reply to this post by Chengxin Li
Doug, thanks for your information and suggestion.
Thanks again! Chengxin >>> Doug S <[hidden email]> 02/27/08 9:50 PM >>> P.S. Chengxin, my idea would require using JAVA to access the Open Office package to write a plugin rather than using the ImageJ macro language. Depending on your experience this might be intimidating, but there is good documentation for writing ImageJ plugins and using the Open Office package is a matter of using their well documented classes so it shouldn't be too bad if you know a little JAVA DOug Chengxin, just an idea . . . I haven't used this package yet but Sun's java IDE NetBeans has recently added integration with an open source package called OpenOffice OpenOffice is essentially a JAVA version of MicroSoft's Office, but its free and open source 8-) It can right EXCEL files as well as its own format: http://www.openoffice.org/ SUN has supported it as an open source package that helps JAVA itself become more powerful Their NetBeans JAVA IDE has a plugin or addon that makes working with OpenOffice easier http://www.netbeans.org/community/magazine/html/03/openoffice/ http://wiki.services.openoffice.org/wiki/OpenOffice_NetBeans_Integration I think its well documented You can do it with other IDEs I'm sure but it may require a little more experience with JAVA packages so it depends on your experience level and how attached you are to a non-NetBeans IDE Good Luck with it . . . I'd like to say I could help more but probably won't be using OPenOffice for a number of months now Doug Chengxin Li wrote: > Hi, > > I am very new to ImageJ, esp. new to Macro coding. I found this is the best forum to get help. > > Currently I am doing Pathology related image measurement. After getting number from ImageJ Result and calculation, I hope to write the result to Excell cell interactively by Macro coding. e.g. computer pops up message:"Where to write ?", I input C5, then write the value to Excell C5 cell. Next time, I may input D5, then write to D5. I wonder any possible to implement this in Macro, and how ? > > Thank you very much for your help ! > > Chengxin > > |
«
Return to ImageJ
|
1 view|%1 views
| Free forum by Nabble | Edit this page |