Deleting pictures from Excel: Shapes.Item.Delete doesn't work

1 次查看（过去 30 天）
AR
AR 2018-8-1
编辑： Walter Roberson 2018-8-13
I have an Excel sheet (assume sheet 5) with several images in it. That is to say .jpg or .png. I do this:
... blah blah...
sheethandle = get(Sheets, 'Item', 5);
invoke(sheethandle, 'Activate');
Activesheet = Excel.Activesheet;
Shapes = sheethandle.Shapes;
for s = Shapes.Count:-1:1
Shapes.Item(s).Delete;
end
At this point, the Shapes variable shows a count of 0 when examined in the workspace. However, the Excel sheet still shows all the images intact. What do I need to do to make it work?

请先登录，再回答此问题。

回答（1 个）

Othmane ELMOUATAMID
编辑：Othmane ELMOUATAMID 2018-8-13
Hi AR,
Check this answer.
  1 个评论
AR
AR 2018-8-13
I have seen this answer before. As far as I can tell, this is exactly what I am doing (reported above), but isn't exactly working. Thanks.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by