Insert multiple plots to excel sheets using ActiveX
显示 更早的评论
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
采纳的回答
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
更多回答（0 个）
类别
在 帮助中心 和 File 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 
