Worksheet.Copy

Copy(Worksheet)

Copies contents and formats from another worksheet.

public void Copy(Worksheet sourceSheet)
ParameterTypeDescription
sourceSheetWorksheetSource worksheet.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class WorksheetMethodCopyWithWorksheetDemo
    {
        public static void Run()
        {
            // Create a source workbook with sample data
            Workbook sourceWorkbook = new Workbook();
            Worksheet sourceSheet = sourceWorkbook.Worksheets[0];
            sourceSheet.Cells["A1"].PutValue("Source Worksheet");
            
            // Create a destination workbook
            Workbook destWorkbook = new Workbook();
            Worksheet destSheet = destWorkbook.Worksheets[0];
            
            // Copy the source worksheet to the destination worksheet
            destSheet.Copy(sourceSheet);
            
            // Save the result
            destWorkbook.Save("output.xlsx");
        }
    }
}

See Also

Copy(Worksheet, CopyOptions)

Copies contents and formats from another worksheet.

public void Copy(Worksheet sourceSheet, CopyOptions copyOptions)
ParameterTypeDescription
sourceSheetWorksheetSource worksheet.
copyOptionsCopyOptions

Remarks

You can copy data from another worksheet in the same file or another file. However, this method does not support to copy drawing objects, such as comments, images and charts.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class WorksheetMethodCopyWithWorksheetCopyOptionsDemo
    {
        public static void Run()
        {
            // Create source workbook with sample data
            Workbook srcWorkbook = new Workbook();
            Worksheet srcSheet = srcWorkbook.Worksheets[0];
            srcSheet.Name = "SourceSheet";
            srcSheet.Cells["A1"].PutValue("Source Data");

            // Create destination workbook
            Workbook destWorkbook = new Workbook();
            Worksheet destSheet = destWorkbook.Worksheets[0];
            destSheet.Name = "DestinationSheet";

            // Configure copy options
            CopyOptions options = new CopyOptions();
            options.ReferToDestinationSheet = true;

            // Copy worksheet with options
            srcSheet.Copy(destSheet, options);

            // Verify the copy operation
            Console.WriteLine("Copied cell value: " + destSheet.Cells["A1"].StringValue);
            
            // Save the result
            destWorkbook.Save("output.xlsx", SaveFormat.Xlsx);
        }
    }
}

See Also