Save different results to different Excel datasheets

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

Save different results to different Excel datasheets

Veronica Labrador Cantarero
Dear List,

     Using the ‘Macros-Record…’ function I have created a macro to get the intensity values along several line-ROIs with the Plot Profile tool.

      It saves each ‘Plot Values’ table in a different Excel file so the higher the number of ROIs the higher the number of Excel files for an image.

     Do you know how to create datasheets within an Excel file? This way I could save each ‘Plot Values’ data in a different datasheet.  Is this possible?

     I have the Excel Writer plugin but I do not know how to write its commands in macro language (such as creating a new Excel datasheet).

Any help would be greatly appreciated.

Thank you in advance,

Veronica Labrador Cantarero

Servicio de Microscopia Optica y Confocal
Centro de Biologia Molecular Severo Ochoa
C/Nicolas Cabrera,1
Universidad Autónoma de Madrid
Madrid (Spain)
http://www.cbm.uam.es/confocal