Aspose.Cells 复制行和列（复制单行，复制多行，复制单列，复制多列）

青旅半醒 2023-10-05 16:27 30阅读 0赞

### 1 复制单行 ###

#### 1.1 CopyRow(Cells sourceCells, int sourceRowIndex, int destinationRowIndex) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //将第一行内容复制到第二行
    cells.CopyRow(cells, 0, 1);

#### 1.2 CopyRows(Cells sourceCells, int sourceRowIndex, int destinationRowIndex, int rowNumber) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //将第一行内容复制到第二行
    cells.CopyRows(cells, 0, 1,1);

### 2 复制多行 ###

CopyRows(Cells sourceCells, int sourceRowIndex, int destinationRowIndex, int rowNumber)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //将第一行起两行的内容复制到第三行
    cells.CopyRows(cells, 0, 2,2);

### 3 复制单列 ###

#### 3.1 CopyColumn(Cells sourceCells, int sourceColumnIndex, int destinationColumnIndex) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //将第一列内容复制到第二列
    cells.CopyColumn(cells, 0, 1);

#### 3.2 CopyColumns(Cells sourceCells, int sourceColumnIndex, int destinationColumnIndex, int columnNumber) ####

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //将第一列内容复制到第二列
    cells.CopyColumns(cells, 0, 1,1);

### 4 复制多列 ###

CopyColumns(Cells sourceCells, int sourceColumnIndex, int destinationColumnIndex, int columnNumber)

Workbook workbook=new Workbook();
    WorkSheet worksheet=workbook.WorkSheet[0];
    Cells cells=worksheet.Cells;
    //将第一列起两列的内容复制到第三列
    cells.CopyColumns(cells, 0, 2,2);

注：复制行和列只是复制单元格的内容，不包括单元格样式和单元格本身。