Copy or Move Worksheets in Excel Files using Java

readme.md

Read the complete article on copying worksheets in Excel files using Java: https://blog.aspose.com/2021/07/08/copy-worksheets-in-excel-files-using-java/

copy-worksheet.java

// Load the Excel file using its path
Workbook wb = new Workbook("book1.xls");

// Access the worksheets in the workbook
WorksheetCollection sheets = wb.getWorksheets();

// Create a copy of the worksheet
sheets.addCopy("Sheet1");

// Save the updated Excel file
wb.save("updated.xls");

copy-worksheets-in-workbooks.java

// Load the source Excel workbook
Workbook source = new Workbook("source.xls");

// Load the destination Excel workbook
Workbook destination = new Workbook("destination.xls");

// Copy the first sheet of the source workbook into second workbook
destination.getWorksheets().get(0).copy(source.getWorksheets().get(0));

// Save the file.
destination.save("updated.xls", FileFormatType.EXCEL_97_TO_2003);

move-worksheet.java

// Load the Excel file
Workbook wb = new Workbook("workbook.xls");

// Get the first worksheet in the workbook
Worksheet sheet = wb.getWorksheets().get(0);

// Move the first sheet to the third position in the workbook
sheet.moveTo(2);

// Save the updated Excel file
wb.save("updated.xls");