Aspose.Cells 删除行、列、指定单元格（删除单行，删除多行，删除单列，删除多列，删除指定单元格）

曾经终败给现在 2023-10-05 16:29 2阅读 0赞

### 1 删除单行 ###

#### 1.1 DeleteRow(int rowIndex) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一行
    cells.DeleteRow(0);

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

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一行
    cells.DeleteRows(0,1);

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

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一行
    cells.DeleteRows(0,1,false);

### 2 删除多行 ###

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

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一行起两行的单元格
    cells.DeleteRows(0,2);

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

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一行起两行的单元格
    cells.DeleteRows(0,2,false);

### 3 删除单列 ###

#### 3.1 DeleteColumn(int columnIndex) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一列
    cells.DeleteColumn(0);

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

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一列
    cells.DeleteColumn(0,false);

#### 3.3 DeleteColumns(int columnIndex, int totalColumns, bool updateReference) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一列
    cells.DeleteColumns(0,1,false);

### 4 删除多列 ###

DeleteColumns(int columnIndex, int totalColumns, bool updateReference)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一列起两列的单元格
    cells.DeleteColumns(0,2,false);

### 5 删除指定单元格 ###

DeleteRange(int startRow, int startColumn, int endRow, int endColumn, ShiftType shiftType)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //删除第一行第一列至第二行第二列之间的4个单元格
    cells.DeleteRange(0,0,1,1);

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