完成粘贴操作后检测工作簿中新形状的正确方法

Question

所以我目前正在这样做...

//Codeblock edited to include otaku upgrade
const String GIFpastespecialformat = @"Picture (GIF)";
const Int32 Onemoreshape = 1;
Int32 shapeCount = sht.Shapes.Count;
WorksheetPasteSpecialArgs wspa = new worksheetpastespecialargs();
wspa.Format = GIFpastespecialformat;
wspa.Link = False;
wspa.DisplayAsIcon = False;
List<Int32> oldShapes = new List<Int32>();
foreach (var item in sht.Shapes.Items())
{
   oldShapes.Add(Item.ID);
}
sht.PasteSpecial(wspa);
if((shapeCount + Onemoreshape) == sht.Shapes.Count)
{
  foreach (var item in sht.Shapes.Items())
  {
    if(oldShapes.Exists(i => i == item.ID) == false)
    {
      //work with shape here
    }
  }
}
else
{ 
   //report and deal with comexception, user intervention, etc
}

其中 sht 是代表我正在使用的工作表的变量。

Answer 1

代码相当扎实。也许我要做的唯一增强就是保留形状的计数 - oldShapes.Count 并查看粘贴后该数字是否发生变化。如果是这样，则已插入一个形状。