C# Excel 删除指定行 Excel delete row

C# Excel 删除指定行 Excel delete row
ws = worksheet

删除一行 To delete a single row this way:

1. Excel.Range ran;
   
2. ran = (Excel.Range)this.Application.Rows[12, missing];
   
3. ran.Select();
   
4. ran.Delete(Microsoft.Office.Interop.Excel.XlDirection.xlUp);
   
5. 
   

复制代码

同时连续删除多行To delete multiple rows:

1. 
   
2. //Get a set of cells in the rows
   
3. Excel.Range rng = ws.get_Range("a12", "A14");
   
4. //Then act on the entire rows of the range
   
5. rng.EntireRow.Delete(Excel.XlDirection.xlUp);
   

复制代码