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

　　因此當(dāng)您需要插入多行或刪除多行時(shí)，我們推薦您使用InsertRows和DeleteRows方法，而不是在循環(huán)中重復(fù)使用InsertRow和DeleteRow 。

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

下例演示了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");