List<Shape> listPicIndex = new List<Shape>();
for (int i = 1; i <= myWorkSheet.Shapes.Count; i++)
{
Shape shp = myWorkSheet.Shapes.Item(i);
Range r = shp.TopLeftCell;
//int nn = r.Column;
//int rr = r.Row;
if (listKeep.IndexOf(r.Row) < 0)
{
if (r.Column >= 21 && r.Column <= 28)
{
//DelMoule del = new DelMoule();
//del.Pic = shp;
//del.Rag = r;
listPicIndex.Add(shp);
}
}
}
foreach (Shape nTemp in listPicIndex)
{
nTemp.Delete();
//nTemp.Rag.Delete();
// myWorkSheet.Rows.Delete(nTemp.Rag.Row);
//nTemp.Rag.EntireRow.Delete(XlDeleteShiftDirection.xlShiftUp);
}
for (int i = 1; i <= myWorkSheet.Shapes.Count; i++)
{
Shape shp = myWorkSheet.Shapes.Item(i);
Range r = shp.TopLeftCell;
//int nn = r.Column;
//int rr = r.Row;
if (listKeep.IndexOf(r.Row) < 0)
{
if (r.Column >= 21 && r.Column <= 28)
{
//DelMoule del = new DelMoule();
//del.Pic = shp;
//del.Rag = r;
listPicIndex.Add(shp);
}
}
}
foreach (Shape nTemp in listPicIndex)
{
nTemp.Delete();
//nTemp.Rag.Delete();
// myWorkSheet.Rows.Delete(nTemp.Rag.Row);
//nTemp.Rag.EntireRow.Delete(XlDeleteShiftDirection.xlShiftUp);
}