Copy Rows and Columns in Excel using Java

readme.md

Read the complete article on copying the rows and columns in Excel worksheets using Java:

copy-columns.java

// Instantiating a Workbook object
Workbook workbook = new Workbook("workbook.xlsx");

// Obtaining the reference of the first worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(0);

// Copy the first column from the first worksheet of the workbook
worksheet.getCells().copyColumn(worksheet.getCells(), worksheet.getCells().getColumns().get(0).getIndex(), worksheet.getCells().getColumns().get(2).getIndex());

// Saving the Excel file
workbook.save("output.xlsx");

copy-rows.java

// Instantiating a Workbook object
Workbook workbook = new Workbook("workbook.xlsx");

// Obtaining the reference of the first worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(0);

// Copy the second row with data, formating, images and drawing objects to the 16th row in the worksheet
worksheet.getCells().copyRow(worksheet.getCells(), 1, 15);

// Saving the Excel file
workbook.save("output.xlsx");