使用XSSFRangeCopier跨工作簿将多个excel汇总到一个excel的多个sheet

最新推荐文章于 2022-10-18 13:34:55 发布

咋还得起名

最新推荐文章于 2022-10-18 13:34:55 发布

阅读量940

点赞数

文章标签： java poi excel

本文链接：https://blog.csdn.net/weixin_40897480/article/details/121794165

版权

目前查到的都是一个单元格一个单元格复制的，这种方式写起来简单一些

XSSFWorkbook workbookFrom = new XSSFWorkbook(new File("/path/to/workbookFrom.xlsx"));
XSSFSheet sheetFrom = workbookFrom.getSheetAt(0);

XSSFWorkbook workbookTo = new XSSFWorkbook(new File("/path/to/workbookTo.xlsx"));
XSSFSheet sheetTo = workbookTo.createSheet("sheet1");

XSSFRangeCopier xssfRangeCopier = new XSSFRangeCopier(sheetFrom, sheetTo);
//copy the row height and column width, and find the max column num
int lastRow = sheetFrom.getLastRowNum();
int lastCol = 0;
for (int i = 0; i < lastRow; i++) {
    Row row = sheetFrom.getRow(i);
    if (row != null) {
        if (row.getLastCellNum() > lastCol) {
            lastCol = row.getLastCellNum();
        }
        sheetTo.setDefaultRowHeight(sheetFrom.getDefaultRowHeight());
    }
}

for (int j = 0; j < lastCol; j++) {
    sheetTo.setColumnWidth(j, sheetFrom.getColumnWidth(j));
}

//copy contents from source sheet to destination sheet
CellRangeAddress cellAddresses = new CellRangeAddress(0, lastRow, 0, lastCol);
xssfRangeCopier.copyRange(cellAddresses, cellAddresses);

workbookTo.write(new FileOutputStream(new File("/path/to/worksheetTo.xlsx")));