您是否希望工作表可以輕松地隨著經常變化的業務需求而同步更新？使用Aspose.Cells APIs，您可以快速插入新行、列、單元格以及工作薄—并可輕松刪除它們 — 僅需要調用一些方法，便可輕松完美地實現。當在創建一個新的工作薄或正在操作一個已有的工作薄時，您可能會需要添加額外的行/列來滿足更多的數據或其它特殊需求。同樣，您還可能需要從特定的位置或工作薄區域內刪除行/列。因此，Aspose.Cells 提供了最簡單的API集來輕松滿足您的需求。Aspose.Cells對此提供了兩個方法。即InsertRows和 DeleteRows，這兩個方法可以輕松并完美地完成這個任務。

　　因此當您需要插入多行或刪除多行時，我們推薦您使用InsertRows和DeleteRows方法，而不是在循環中重復使用InsertRow和DeleteRow 。

　　Aspose.Cells工作方式和MS Excel 一樣。當添加行或列時，工作薄中的內容將會向下或右移。如果刪除行或列時，工作薄中的內容會像上或左移。此外，其它工作薄中涉及的內容將會隨著插入/刪除行而更新。

下例演示了InsertRows 和DeleteRows 方法的使用：

[C#]

//Instantiate a Workbook object.
Workbook workbook = new Workbook();
//Load a template file.
workbook.Open("d:\\test\\MyBook.xls");
//Get the first worksheet in the book.
Worksheet sheet = workbook.Worksheets[0];
//Insert 10 rows at row index 2 (insertion starts at 3rd row)
sheet.Cells.InsertRows(2, 10);
//Delete 5 rows now. (8th row – 12th row)
sheet.Cells.DeleteRows(7, 5);
//Save the excel file.
workbook.Save("d:\\test\\out_MyBook.xls");

[VB]

‘Instantiate a Workbook object.
Dim workbook As Workbook = New Workbook
‘Load a template file.
workbook.Open("d:\test\MyBook.xls")
‘Get the first worksheet in the book.
Dim sheet As Worksheet = workbook.Worksheets(0)
‘Insert 10 rows at row index 2 (insertion starts at 3rd row)
sheet.Cells.InsertRows(2, 10)
‘Delete 5 rows now. (8th row – 12th row)
sheet.Cells.DeleteRows(7, 5)
‘Save the excel file.
workbook.Save("d:\test\out_MyBook.xls")

[Java]

//Instantiate a Workbook object.
Workbook workbook = new Workbook();
//Load a template file.
workbook.open("d:\\test\\MyBook.xls");
//Get the first worksheet in the book.
Worksheet sheet = workbook.getWorksheets().getSheet(0);
//Insert 10 rows at row index 2 (insertion starts at 3rd row)
sheet.getCells().insertRows(2, 10);
//Delete 5 rows now. (8th row – 12th row)
sheet.getCells().deleteRows(7, 5,true);
//Save the excel file.
workbook.save("d:\\test\\out_MyBook.xls");