CODEWITHSUNDEEP
javaexcelapache-poi
Shumon Saha
Shumon Saha

Reputation: 1445

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?

Upvotes: 16

Views: 42642

Answers (3)

Cataclysm
Cataclysm

Reputation: 8608

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

Upvotes: 4

Gagravarr
Gagravarr

Reputation: 48376

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

Upvotes: 24

JoseK
JoseK

Reputation: 31371

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.

Upvotes: 5

Related Questions