Insert multiple plots to excel sheets using ActiveX

2 次查看(过去 30 天)
Hi, I have a function where I create about 30 plots in a for loop. Now I would like to put each plot, as a pitcture, into a seperate excel sheet in the same excel document.
, they show how to do it for one plot, but as I dont want to write sheet1.... sheet 2.... sheet 3 and so on, I wonder if there is a way to to this in a for loop to make things a bit more convenient!
Thank's a lot! Fredrik

采纳的回答

Eric
Eric 2012-10-30
编辑:Eric 2012-10-30
First create as many sheets as you want (using Sheets.Add()).
Then loop through your plots, calling
Sheet1 = get(Sheets, 'Item', ctr);
where I have assumed ctr is the loop variable. Sheet1 (or call it something else if you like) will then be a reference to the ctr-th Worksheet.
So you could do something like:
for ctr = 1:N
Sheets.Add(); %Add a new sheet each time through the loop
Sheet1 = Sheets.Item(ctr); %Extract the ctr-th Worksheet
... %Plotting code here& ...
end
Good luck,
-Eric
  1 个评论
Fredrik
Fredrik 2012-10-30
Thanks a lot!
I managed to do something similar with the help of other functions but I think this would be even better..
/Fredrik

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by