Thread Subject:

writing MATLAB images into Excel worksheets

Does anyone have a method to write an image from MATLAB into Excel worksheets? The Shapes.AddPicture command isn't working for me. My application is to pull images from a number of separate directories and compile them into a single document with images from each test group on a separate worksheet.

Thanks in advance for any pointers!
Cindy

On Tue, 06 Oct 2009 19:14:02 -0400, Cynthia
<remove.this.cynthia.bell@asu.edu> wrote:

> Does anyone have a method to write an image from MATLAB into Excel
> worksheets? The Shapes.AddPicture command isn't working for me. My
> application is to pull images from a number of separate directories and
> compile them into a single document with images from each test group on
> a separate worksheet.
>
> Thanks in advance for any pointers!
> Cindy

Is this what you tried?
"How do I insert a MATLAB figure into an Excel Workbook through ActiveX?"
http://www.mathworks.com/support/solutions/en/data/1-1BHK6/?solution=1-1BHK6

In what way is it not working for you?
i.e. Does it error out or not result in expected output (if so, what is
the deviation?)?

"Cynthia " <remove.this.cynthia.bell@asu.edu> wrote in message <hagivq$qtp$1@fred.mathworks.com>...
> Does anyone have a method to write an image from MATLAB into Excel worksheets? The Shapes.AddPicture command isn't working for me. My application is to pull images from a number of separate directories and compile them into a single document with images from each test group on a separate worksheet.
>
> Thanks in advance for any pointers!
> Cindy

Try to use the OfficeDoc utility on the File Exchange: http://www.mathworks.com/matlabcentral/fileexchange/15192

Yair Altman
http://ymasoftware.com

On Oct 6, 7:14 pm, "Cynthia " <remove.this.cynthia.b...@asu.edu>
wrote:
> Does anyone have a method to write an image from MATLAB into Excel worksheets?  The Shapes.AddPicture command isn't working for me.  My application is to pull images from a number of separate directories and compile them into a single document with images from each test group on a separate worksheet.
>
> Thanks in advance for any pointers!
> Cindy

--------------------------------------------------------------------------------
It appears that you're not monitoring this thread anymore Cynthia, but
just for completeness I thought I'd reference my answer in your
duplicate thread:
http://www.mathworks.com/matlabcentral/newsreader/view_thread/262481#685360