插入、删除行和列

介绍

无论是从头开始创建新的工作表还是在现有工作表上工作，我们可能需要添加额外的行或列来容纳更多数据。相反，我们也可能需要从工作表中的指定位置删除行或列。为了满足这些要求，Aspose.Cells提供了一组非常简单的类和方法，如下所述。

管理行和列

Aspose.Cells提供了一个表示Microsoft Excel文件的类，Workbook，该类包含一个Worksheets集合，允许访问Excel文件中的每个工作表。工作表由Worksheet类表示。Worksheet类提供了一个表示工作表中所有单元格的Cells集合。

Cells集合提供了几种管理工作表中行和列的方法。以下讨论了其中一些。

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

插入行

通过调用Cells集合的InsertRow方法，在工作表的任何位置插入一行。InsertRow方法接受新行将被插入的行的索引。

Aspose::Cells::Startup();

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

//Path of input
U16String dirPath(u"");

//Path of output
U16String outPath(u"");

//Path of input excel file
U16String sampleInsertingDeletingRowsAndColumns = dirPath + u"sampleInsertingDeletingRowsAndColumns.xlsx";

//Path of output excel file
U16String outputInsertingDeletingRowsAndColumns = outPath + u"outputInsertingDeletingRowsAndColumns.xlsx";

//Read input excel file
Workbook workbook(sampleInsertingDeletingRowsAndColumns);

//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().InsertColumn(1);

//Save the Excel file.
workbook.Save(outputInsertingDeletingRowsAndColumns);

Aspose::Cells::Cleanup();

插入多行

要在工作表中插入多行，调用Cells集合的InsertRows方法。InsertRows方法接受两个参数：

• 行索引，新行将从该行插入。
• 行数，需要插入的总行数。

Aspose::Cells::Startup();

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

//Path of input
U16String dirPath(u"");

//Path of output
U16String outPath(u"");

//Path of input excel file
U16String sampleInsertingDeletingRowsAndColumns = dirPath + u"sampleInsertingDeletingRowsAndColumns.xlsx";

//Path of output excel file
U16String outputInsertingDeletingRowsAndColumns = outPath + u"outputInsertingDeletingRowsAndColumns.xlsx";

//Read input excel file
Workbook workbook(sampleInsertingDeletingRowsAndColumns);

//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);

//Save the Excel file.
workbook.Save(outputInsertingDeletingRowsAndColumns);

Aspose::Cells::Cleanup();

删除多行

要从工作表中删除多行，调用Cells集合的DeleteRows方法。DeleteRows方法接受两个参数：

• 行索引，要删除行的索引。
• 行数，需要删除的总行数。

Aspose::Cells::Startup();

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

//Path of input
U16String dirPath(u"");

//Path of output
U16String outPath(u"");

//Path of input excel file
U16String sampleInsertingDeletingRowsAndColumns = dirPath + u"sampleInsertingDeletingRowsAndColumns.xlsx";

//Path of output excel file
U16String outputInsertingDeletingRowsAndColumns = outPath + u"outputInsertingDeletingRowsAndColumns.xlsx";

//Read input excel file
Workbook workbook(sampleInsertingDeletingRowsAndColumns);

//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);

//Save the Excel file.
workbook.Save(outputInsertingDeletingRowsAndColumns);

Aspose::Cells::Cleanup();

插入列

开发人员还可以通过调用Cells集合的InsertColumn方法，在工作表的任何位置插入列。InsertColumn方法接受新列将被插入的列的索引。

Aspose::Cells::Startup();

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

//Path of input
U16String dirPath(u"");

//Path of output
U16String outPath(u"");

//Path of input excel file
U16String sampleInsertingDeletingRowsAndColumns = dirPath + u"sampleInsertingDeletingRowsAndColumns.xlsx";

//Path of output excel file
U16String outputInsertingDeletingRowsAndColumns = outPath + u"outputInsertingDeletingRowsAndColumns.xlsx";

//Read input excel file
Workbook workbook(sampleInsertingDeletingRowsAndColumns);

//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().InsertColumn(1);

//Save the Excel file.
workbook.Save(outputInsertingDeletingRowsAndColumns);

Aspose::Cells::Cleanup();

删除列

要从工作表中的任何位置删除列，调用Cells集合的DeleteColumn方法。DeleteColumn方法接受要删除的列的索引。

Aspose::Cells::Startup();

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

//Path of input
U16String dirPath(u"");

//Path of output
U16String outPath(u"");

//Path of input excel file
U16String sampleInsertingDeletingRowsAndColumns = dirPath + u"sampleInsertingDeletingRowsAndColumns.xlsx";

//Path of output excel file
U16String outputInsertingDeletingRowsAndColumns = outPath + u"outputInsertingDeletingRowsAndColumns.xlsx";

//Read input excel file
Workbook workbook(sampleInsertingDeletingRowsAndColumns);

//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().DeleteColumn(1);

//Save the Excel file.
workbook.Save(outputInsertingDeletingRowsAndColumns);

Aspose::Cells::Cleanup();