Copy Excel Sheet using Apache POI

12
votes

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

3
javaexcelapache-poi
stackoverflow.com/questions/5889639/apache-poi-copying-sheets – Ivan Sopov
@IvanSopov, thank you for the URL, but that question is how to copy sheets between different workbooks, whereas my question is how to copy sheets in the same workbook. – Shumon Saha

3 Answers

20
votes

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

4
votes

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.

2
votes

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);
            }