IronXL を使って C# でセルをコピーする方法

単一セルのコピー例

選択されたセルの内容をコピーするには、Copyメソッドを使用できます。 ワークシートオブジェクトを最初のパラメーターとして渡し、開始位置を2番目のパラメーターとして渡します。 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")

出力スプレッドシート

セル範囲のコピー例

Similar to the Clear method, this method is also available in the Range class, allowing you to execute it on any range, regardless of its size. Here are some examples:

• 単一セルをコピー (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")

出力スプレッドシート

ワークシート全体にセルをコピーする例

最初のパラメーターはワークシートオブジェクトを受け入れるため、異なるワークシートにまたがってセル範囲をコピー＆ペーストすることが可能です。 単に異なるワークシートオブジェクトを最初のパラメーターとして渡します。

// Example Code: Copy cells across different worksheets in IronXL

using IronXL;

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

// Example Code: Copy cells across different worksheets in IronXL

using IronXL;

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");

' Example Code: Copy cells across different worksheets in IronXL

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")