Copy Excel Sheet using Apache POI

问题:

How to copy one entire Excel sheet into another Excel sheet of the same workbook, using Java SE and Apache POI?

回答1:

You'll probably want the cloneSheet(sheetNumber) method on the Workbook. See the JavaDocs for details

回答2:

Did you check the API?

to copy a sheet into the same workbook, use HSSFWorkbook.clonesheet(int sheetIndex)

Ivan's comment has linked the question for copying across workbooks.

回答3:

Yes , this can be...Here my code.

            XSSFWorkbook workbook = new XSSFWorkbook(file);
            int totalRecords = 5;
            for (int i = 0; i < totalRecords - 1; i++) {
                workbook.cloneSheet(1);
            }
            for (int i = 1; i <= totalRecords; i++) {
                workbook.setSheetName(i, "S" + i);
            }