Exporting to Excel

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Exporting to Excel

Lee Hampson
Hello all

Currently I have a macro that asks the user to draw a series of lines through an image and exports the plot profile data to an Excel file.  The user draws 12 lines so I end up with 12 Excel files.  Is it possible to have a macro that will place the 12 data sets into one single Excel file that would contain 12 sheets, one for each data set?  Or if I can't do that to have all the data saved into a single sheet where I can specify specific columns for the data to be entered into, so that I could save the first plot profile data into columns A and B and the second into columns D and E etc?

I think it is possible to merge the separate workbooks into one using an Excel macro but I'd rather do this via ImageJ if it is at all possible.

Thanks
Lee

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html
Reply | Threaded
Open this post in threaded view
|

Re: Exporting to Excel

Krs5
Dear Lee,

Maybe the example http://imagej.nih.gov/ij/macros/CustomTabStatFromResults.txt can point you in the right direction.

Best wishes

Kees

-----Original Message-----
From: ImageJ Interest Group [mailto:[hidden email]] On Behalf Of Lee Hampson
Sent: 14 November 2013 09:26
To: [hidden email]
Subject: Exporting to Excel

Hello all

Currently I have a macro that asks the user to draw a series of lines through an image and exports the plot profile data to an Excel file.  The user draws 12 lines so I end up with 12 Excel files.  Is it possible to have a macro that will place the 12 data sets into one single Excel file that would contain 12 sheets, one for each data set?  Or if I can't do that to have all the data saved into a single sheet where I can specify specific columns for the data to be entered into, so that I could save the first plot profile data into columns A and B and the second into columns D and E etc?

I think it is possible to merge the separate workbooks into one using an Excel macro but I'd rather do this via ImageJ if it is at all possible.

Thanks
Lee

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html