如何使用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")