MATLAB Central Newsreader - Writing images into Excel file

Writing images into Excel file

Bojan — Mon, 14 Apr 2008 13:30:21 -0400

I am using xlswrite to output data from a calculation. I
would also like to output some figures in the same excel
file. Is it possible to write a bitmap or a tif into excel
spreadsheet using xlswrite or some other command?
Many thanks
Bojan

Re: Writing images into Excel file

avan — Mon, 14 Apr 2008 13:52:53 -0400

On Apr 14, 3:30 pm, "Bojan " <bobrado...@illumina.com> wrote:
> I am using xlswrite to output data from a calculation. I
> would also like to output some figures in the same excel
> file. Is it possible to write a bitmap or a tif into excel
> spreadsheet using xlswrite or some other command?
> Many thanks
> Bojan

Why don't you just print the figures into bitmap or tif files and then
insert them manually from excel? You can also try to copy the figure
and paste it in excel.

Avan

Re: Writing images into Excel file

Phil Goddard — Mon, 14 Apr 2008 18:20:19 -0400

xlswrite won't do it for you, but you can do pretty much
anything to an Excel spreadsheet from within MATLAB by
opening a COM connection.
Have a look at
>> doc actxserver
for info on opening such a connection.

From there you need to know the appropriate ActiveX methods
to create and insert the image.
That is not trivial and will take some trial and error.

A good start is to do the image insertion manually from
within Excel while recording your steps as a macro.
Then look at the macro to see the types of commands that
you'll need to use from within MATLAB to do it
automatically.

Phil.

Re: Writing images into Excel file

Jason — Wed, 16 Apr 2008 12:57:02 -0400

"Bojan " <bobradovic@illumina.com> wrote in message
<ftvm9d$idk$1@fred.mathworks.com>...
> I am using xlswrite to output data from a calculation. I
> would also like to output some figures in the same excel
> file. Is it possible to write a bitmap or a tif into
excel
> spreadsheet using xlswrite or some other command?
> Many thanks
> Bojan
Can you not set up a com link?