Aspose.Cells 插入行和列（插入单行、插入多行、插入单列、插入多列）

灰太狼 2023-10-05 16:32 17阅读 0赞

### 1 插入单行 ###

#### 1.1 InsertRow(int rowIndex) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一行之前插入一行
    cells.InsertRow(0);

#### 1.2 InsertRows(int rowIndex, int totalRows) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一行之前插入一行
    cells.InsertRows(0,1);

#### 1.3 InsertRows(int rowIndex, int totalRows, bool updateReference) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一行之前插入一行
    cells.InsertRows(0,1,false);

### 2 插入多行 ###

#### 2.1 InsertRows(int rowIndex, int totalRows) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一行之前插入两行
    cells.InsertRows(0,2);

#### 2.2 InsertRows(int rowIndex, int totalRows, bool updateReference) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一行之前插入两行
    cells.InsertRows(0,2,false);

### 3 插入单列 ###

#### 3.1 InsertColumn(int columnIndex) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一列之前插入一列
    cells.InsertColumn(0);

#### 3.2 InsertColumn(int columnIndex, bool updateReference) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一列之前插入一列
    cells.InsertColumn(0,false);

#### 3.3 InsertColumns(int columnIndex, int totalColumns) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一列之前插入一列
    cells.InsertColumns(0,1);

#### 3.4 InsertColumns(int columnIndex, int totalColumns, bool updateReference) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一列之前插入一列
    cells.InsertColumns(0,1,false);

### 4 插入多列 ###

#### 4.1 InsertColumns(int columnIndex, int totalColumns) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一列之前插入两列
    cells.InsertColumns(0,2);

#### 4.2 InsertColumns(int columnIndex, int totalColumns, bool updateReference) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //在第一列之前插入两列
    cells.InsertColumns(0,2,false);

注：

（1）插入的行或列位于指定的行或列之前。

（2）本博客的内容有一些瑕疵，大家在根据这篇博客的内容，应用到实际项目中的时侯碰到了问题请联系本博主。