Excel
来源:互联网 发布:cnpm 安装node sass 编辑:程序博客网 时间:2024/05/29 04:58
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);
}
0 0
- Excel
- Excel
- ExCel
- excel
- Excel
- EXCEL
- excel
- excel
- EXCEL
- Excel
- excel
- Excel
- excel
- excel
- excel
- EXCEL
- excel
- excel
- 《Eclipse从入门到精通》(pdf)计算机电子书下载
- 由于未能创建 Microsoft Visual C# 2008 编译器,因此未能打开项目 "xxx"
- php cookie session的使用
- 希尔排序
- mysql 字符集处理
- Excel
- Oracle字符集的查询和修改
- NSUserDefault的plist文件的位置
- 推送通知
- 零基础入门jQuery视频教程
- CentOS6 离线bash漏洞修复方法
- Note7:String regionMatches查询一段话里有没有关键字 indexOf值得注意的地方
- android 计数器
- 输出一个数的全排列