插入和删除行和列

介绍

无论是从头开始创建新工作表还是处理现有工作表，我们都可能需要添加额外的行或列以容纳更多数据。反之，我们可能还需要删除工作表中指定位置的行或列。

为满足这些要求，Aspose.Cells 提供了一组非常简单的类和方法，如下所述。

管理行/列

Aspose.Cells提供了工作簿表示 Microsoft Excel 文件的类。这工作簿类包含一个工作表集合允许访问 Excel 文件中的每个工作表。工作表由工作表班级。这工作表类提供了Cells代表工作表中所有单元格的集合。

这Cellscollection 提供了多种方法来管理工作表中的行和列。下面讨论其中一些。

添加行或列时，工作表中的内容会向下或向右移动，但如果删除行或列，则内容会向上或向左移动。

插入一行

通过调用[插入行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#insertRows(int,%20int) 的方法Cells收藏。这插入行方法将要插入新行的行的索引作为第一个参数，将要插入的行数作为第二个参数。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
String dataDir = Utils.getSharedDataDir(InsertingARow.class) + "rows_cloumns/";
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "book1.xls");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

// Inserting a row into the worksheet at 3rd position
worksheet.getCells().insertRows(2, 1);

// Saving the modified Excel file in default (that is Excel 2000) format
workbook.save(dataDir + "InsertingARow_out.xls");

插入多行

要将多行插入工作表，请调用[插入行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#insertRows(int,%20int) 的方法Cells收藏。这[插入行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#insertRows(int,%20int)方法有两个参数：

• 行索引：将插入新行的行的索引。
• 行数：需要插入的总行数。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
String dataDir = Utils.getSharedDataDir(InsertingMultipleRows.class) + "rows_cloumns/";
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "book1.xls");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

// Inserting 10 rows into the worksheet starting from 3rd row
worksheet.getCells().insertRows(2, 10);

// Saving the modified Excel file in default (that is Excel 2000) format
workbook.save(dataDir + "InsertingMultipleRows_out.xls");

插入带格式的行

要插入带有格式选项的行，请使用[插入行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#insertRows(int,%20int,%20com.aspose.cells.InsertOptions)超载需要插入选项作为参数。设置复制格式类型的财产插入选项类复制格式类型枚举。这复制格式类型枚举具有三个成员，如下所列。

• 相同的_作为_多于：格式化与上一行相同的行。
• 相同的_作为_以下格式化与下一行相同的行。
• 清除：清除格式。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
String dataDir = Utils.getSharedDataDir(InsertingARowWithFormatting.class) + "RowsAndColumns/";
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

// Setting Formatting options
InsertOptions insertOptions = new InsertOptions();
insertOptions.setCopyFormatType(CopyFormatType.SAME_AS_ABOVE);
      
// Inserting a row into the worksheet at 3rd position
worksheet.getCells().insertRows(2, 1, insertOptions);

// Saving the modified Excel file
workbook.save(dataDir + "InsertingARowWithFormatting_out.xlsx");

删除一行

要删除任何位置的行，请调用[删除行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#deleteRows(int,%20int) 的方法Cells收藏。这[删除行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#deleteRows(int,%20int)方法有两个参数：

• 行索引：将从中删除行的行的索引。
• 行数：需要删除的总行数。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(DeleteARow.class) + "rows_cloumns/";
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "book1.xls");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

// Deleting 3rd row from the worksheet
worksheet.getCells().deleteRows(2, 1, true);

// Saving the modified Excel file in default (that is Excel 2000) format
workbook.save(dataDir + "DeleteARow_out.xls");

删除多行

要从工作表中删除多行，请调用[删除行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#deleteRows(int,%20int) 的方法Cells收藏。这[删除行](https://reference.aspose.com/cells/java/com.aspose.cells/cells#deleteRows(int,%20int)方法有两个参数：

• 行索引：将从中删除行的行的索引。
• 行数：需要删除的总行数。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(DeleteMultipleRows.class) + "rows_cloumns/";
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

// Deleting 10 rows from the worksheet starting from 3rd row
worksheet.getCells().deleteRows(2, 10, true);

// Saving the modified Excel file in default (that is Excel 2000) format
workbook.save(dataDir + "DeleteMultipleRows_out.xls");

插入一列或多列

开发人员还可以通过调用[插入列](https://reference.aspose.com/cells/java/com.aspose.cells/cells#insertColumns(int,%20int) 的方法Cells收藏。这[插入列](https://reference.aspose.com/cells/java/com.aspose.cells/cells#insertColumns(int,%20int)方法有两个参数：

• 列索引，将插入列的列的索引
• Number of columns，需要插入的总列数

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
String dataDir = Utils.getSharedDataDir(InsertingAColumn.class) + "rows_cloumns/";
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "book1.xls");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

// Inserting a column into the worksheet at 2nd position
worksheet.getCells().insertColumns(1, 1);

// Saving the modified Excel file in default (that is Excel 2000) format
workbook.save(dataDir + "InsertingAColumn_out.xls");

删除列

要从工作表的任何位置删除列，请调用[删除列](https://reference.aspose.com/cells/java/com.aspose.cells/cells#deleteColumns(int,%20int,%20boolean) 的方法Cells收藏。这[删除列](https://reference.aspose.com/cells/java/com.aspose.cells/cells#deleteColumns(int,%20int,%20boolean)方法采用以下参数：

• 列索引：列将被删除的列的索引。
• 列数：需要删除的总列数。
• 更新引用：布尔参数，指示是否更新其他工作表中的引用。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(DeleteAColumn.class) + "rows_cloumns/";
// Instantiating a Workbook object
Workbook workbook = new Workbook(dataDir + "Book1.xlsx");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);

// Deleting a column from the worksheet at 2nd position
worksheet.getCells().deleteColumns(1, 1, true);

// Saving the modified Excel file in default (that is Excel 2000) format
workbook.save(dataDir + "DeleteAColumn_out.xls");