Login  Register

select one column from table

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

select one column from table

Noam Harel
3 posts
Hello,

Just a quick and hopefully simple question:

Can I select only one column from a results table to copy and paste into
Excel? I can't figure out how to do this on a histogram list table.

Thanks, Noam Harel
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: select one column from table

Wayne Rasband
1011 posts
> Can I select only one column from a results table to copy and paste
> into
> Excel? I can't figure out how to do this on a histogram list table.

This is one of the "planned features" on the list at
<http://rsb.info.nih.gov/ij/docs/to-do-list.html>.

-wayne
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: select one column from table

Michael Cammer
51 posts
In the meantime....
This is an example of macro code we use to extract columns that are then
printed to the Log window for cut and paste to Excel.

     area = newArray(nResults());
     x = newArray(nResults());
     y = newArray(nResults());
     print("number \t X \t Y \t area \t dist_to_center");
     for (i=0;i<nResults();i++){
       x[i] = getResult("X", i);
       y[i] = getResult("Y", i);
       area[i] =  getResult("Area", i);
       dx = xc - x[i];  dy = yc - y[i];  distance = sqrt ((dx*dx) + (dy*dy));
       print(i+1, "\t", x[i], "\t", y[i], "\t", area[i], "\t", distance);
     }


At 01:16 PM 07/13/06 -0400, you wrote:
>>Can I select only one column from a results table to copy and paste into
>>Excel? I can't figure out how to do this on a histogram list table.
>
>This is one of the "planned features" on the list at
><http://rsb.info.nih.gov/ij/docs/to-do-list.html>.
>
>-wayne

____________________________________________________________________________
Michael Cammer   Analytical Imaging Facility   Albert Einstein Coll. of Med.
URL:  http://www.aecom.yu.edu/aif/