如何使用 IronXL 在 C# 中复制单元格

如何在 Excel 中复制单个单元格？

要复制选定单元格的内容，请使用Copy方法。 将工作表对象作为第一个参数传递，将起始位置作为第二个参数传递。 Copy方法保留所有样式，包括字体和大小、背景图案和颜色以及边框和对齐。

:path=/static-assets/excel/content-code-examples/how-to/copy-cells-copy-single-cell.cs

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.GetWorkSheet("Sheet1");

// Copy cell content
workSheet["A1"].Copy(workBook.GetWorkSheet("Sheet1"), "B3");

workBook.SaveAs("copySingleCell.xlsx");

Imports IronXL

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.GetWorkSheet("Sheet1")

' Copy cell content
workSheet("A1").Copy(workBook.GetWorkSheet("Sheet1"), "B3")

workBook.SaveAs("copySingleCell.xlsx")

复制时保留哪些格式？

Copy方法保留所有单元格属性，包括：

• Cell值和公式
• 数字格式（货币、百分比、日期）
• 字体样式（字体、大小、粗体、斜体、颜色）
• 单元格边框和背景颜色
• 文本对齐（水平和垂直）
• 单元格保护设置

这种全面的保存方式可确保复制的单元格保持其原始外观和功能，类似于在 Microsoft Excel 中使用 Ctrl+C 和 Ctrl+V。

如何复制多个单元格或区域？

与Range类中可用，允许在任何范围大小上执行。当选择范围时，IronXL提供灵活的复制选项：

• 复制单个单元格 (C10)：

  workSheet["C10"].Copy(workBook.GetWorkSheet("Sheet1"), "B13");

  workSheet["C10"].Copy(workBook.GetWorkSheet("Sheet1"), "B13");

  workSheet("C10").Copy(workBook.GetWorkSheet("Sheet1"), "B13")

  $vbLabelText   $csharpLabel

• 复制列 (A)：

  workSheet.GetColumn(0).Copy(workBook.GetWorkSheet("Sheet1"), "H1");

  workSheet.GetColumn(0).Copy(workBook.GetWorkSheet("Sheet1"), "H1");

  workSheet.GetColumn(0).Copy(workBook.GetWorkSheet("Sheet1"), "H1")

  $vbLabelText   $csharpLabel

• 复制行 (4)：

  workSheet.GetRow(3).Copy(workBook.GetWorkSheet("Sheet1"), "A15");

  workSheet.GetRow(3).Copy(workBook.GetWorkSheet("Sheet1"), "A15");

  workSheet.GetRow(3).Copy(workBook.GetWorkSheet("Sheet1"), "A15")

  $vbLabelText   $csharpLabel

• 复制二维范围 (D6:F8)：

  workSheet["D6:F8"].Copy(workBook.GetWorkSheet("Sheet1"), "H17");

  workSheet["D6:F8"].Copy(workBook.GetWorkSheet("Sheet1"), "H17");

  workSheet("D6:F8").Copy(workBook.GetWorkSheet("Sheet1"), "H17")

  $vbLabelText   $csharpLabel

:path=/static-assets/excel/content-code-examples/how-to/copy-cells-copy-cell-range.cs

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.GetWorkSheet("Sheet1");

// Copy a single cell(C10)
workSheet["C10"].Copy(workBook.GetWorkSheet("Sheet1"), "B13");

// Copy a column(A)
workSheet.GetColumn(0).Copy(workBook.GetWorkSheet("Sheet1"), "H1");

// Copy a row(4)
workSheet.GetRow(3).Copy(workBook.GetWorkSheet("Sheet1"), "A15");

// Copy a two-dimensional range(D6:F8)
workSheet["D6:F8"].Copy(workBook.GetWorkSheet("Sheet1"), "H17");

workBook.SaveAs("copyCellRange.xlsx");

Imports IronXL

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.GetWorkSheet("Sheet1")

' Copy a single cell(C10)
workSheet("C10").Copy(workBook.GetWorkSheet("Sheet1"), "B13")

' Copy a column(A)
workSheet.GetColumn(0).Copy(workBook.GetWorkSheet("Sheet1"), "H1")

' Copy a row(4)
workSheet.GetRow(3).Copy(workBook.GetWorkSheet("Sheet1"), "A15")

' Copy a two-dimensional range(D6:F8)
workSheet("D6:F8").Copy(workBook.GetWorkSheet("Sheet1"), "H17")

workBook.SaveAs("copyCellRange.xlsx")

为什么使用GetRow()方法？

GetRow()方法提供：

• 性能：更适合整个行或列
• 清晰度：使代码意图更清晰
• 灵活性：返回支持所有范围操作的Range对象
• 方便性：无需计算完整选择的结束单元

在创建需要全列复制的报告或复制行模板时，这些方法表现出色。

如何在不同工作表之间复制单元格？

第一个参数接受一个工作表对象，以便在不同工作表之间进行复制和粘贴。 将不同的工作表对象作为第一个参数传递。 在管理多个工作表或根据详细数据创建汇总表时，该功能证明是必不可少的。

workBook.GetWorksheet("Sheet2")

:path=/static-assets/excel/content-code-examples/how-to/copy-cells-copy-to-other-worksheet.cs

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.GetWorkSheet("Sheet1");

// Copy cell content
workSheet["A1"].Copy(workBook.GetWorkSheet("Sheet2"), "B3");

workBook.SaveAs("copyAcrossWorksheet.xlsx");

Imports IronXL

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.GetWorkSheet("Sheet1")

' Copy cell content
workSheet("A1").Copy(workBook.GetWorkSheet("Sheet2"), "B3")

workBook.SaveAs("copyAcrossWorksheet.xlsx")

:path=/static-assets/excel/content-code-examples/how-to/copy-cells-5.cs

// Check if worksheet exists before copying
if (workBook.GetWorkSheet("TargetSheet") == null)
{
    workBook.CreateWorkSheet("TargetSheet");
}

// Safe copy operation
WorkSheet targetSheet = workBook.GetWorkSheet("TargetSheet");
sourceSheet["A1:Z100"].Copy(targetSheet, "A1");

Option Strict On



' Check if worksheet exists before copying
If workBook.GetWorkSheet("TargetSheet") Is Nothing Then
    workBook.CreateWorkSheet("TargetSheet")
End If

' Safe copy operation
Dim targetSheet As WorkSheet = workBook.GetWorkSheet("TargetSheet")
sourceSheet("A1:Z100").Copy(targetSheet, "A1")