Copy Rows and Columns in Excel using C#

readme.md

Read the complete article on copying rows and columns in Excel using C#: https://blog.aspose.com/2021/07/15/copy-rows-and-columns-in-excel-using-csharp/

copy-columns.cs

// Load Excel file
Workbook excelWorkbook1 = new Workbook("book1.xlsx");

// Get reference of the first worksheet
Worksheet ws1 = excelWorkbook1.Worksheets[0];

// Copy the first column from the first worksheet of the workbook
ws1.Cells.CopyColumn(ws1.Cells, ws1.Cells.Columns[0].Index, ws1.Cells.Columns[2].Index);

// Autofit the column
ws1.AutoFitColumn(2);

// Save the Excel file
excelWorkbook1.Save("output.xlsx");

copy-rows.cs

// Load Excel file
Workbook excelWorkbook1 = new Workbook("book1.xlsx");

// Get reference of the first worksheet
Worksheet ws1 = excelWorkbook1.Worksheets[0];

// Copy the second row with data, formattings, images and drawing objects to the 16th row in the worksheet
ws1.Cells.CopyRow(ws1.Cells, 1, 15);

// Save the Excel file
excelWorkbook1.Save("output.xlsx");