This article shows you how to duplicate a worksheet inside a workbook using Spire.XLS for Java.
import com.spire.xls.Workbook; import com.spire.xls.Worksheet; public class DuplicateSheetWithinWorkbook { public static void main(String[] args) { //Create a Workbook object Workbook workbook = new Workbook(); //Load the sample Excel file workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\sample.xlsx"); //Get the first worksheet Worksheet originalSheet = workbook.getWorksheets().get(0); //Add a new worksheet Worksheet newSheet = workbook.getWorksheets().add(originalSheet.getName()+" - Copy"); //Copy the worksheet to new sheet newSheet.copyFrom(originalSheet); //Save to file workbook.saveToFile("DuplicateSheet.xlsx"); } }