Cells.CopyRow

Cells.CopyRow method

Copies data and formats of a whole row.

public void CopyRow(Cells sourceCells, int sourceRowIndex, int destinationRowIndex)
ParameterTypeDescription
sourceCellsCellsSource Cells object contains data and formats to copy.
sourceRowIndexInt32Source row index.
destinationRowIndexInt32Destination row index.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class CellsMethodCopyRowWithCellsInt32Int32Demo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            
            // Access first worksheet
            Worksheet worksheet1 = workbook.Worksheets[0];
            Cells cells1 = worksheet1.Cells;
            
            // Add some data to the first row
            cells1["A1"].PutValue("Source Data");
            cells1["B1"].PutValue(100);
            cells1["C1"].PutValue(DateTime.Now);
            
            // Create second worksheet
            Worksheet worksheet2 = workbook.Worksheets.Add("Sheet2");
            Cells cells2 = worksheet2.Cells;
            
            // Copy row from Sheet1 to Sheet2
            cells2.CopyRow(cells1, 0, 0);
            
            // Copy row within Sheet1 to new positions
            cells1.CopyRow(cells1, 0, 1);
            cells1.CopyRow(cells1, 0, 2);
            
            // Save the workbook
            workbook.Save("CopyRowExample.xlsx");
        }
    }
}

See Also