java复制sheet页并将样式和参数带过来

如果你想要复制Sheet页的样式和参数，你可以使用以下代码：

import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.CopySheetResult;
import org.apache.poi.ss.usermodel.IndexedColors;

public class CopySheetExample {
    public static void main(String[] args) throws Exception {
        // 打开Excel文件
        FileInputStream file = new FileInputStream("input.xlsx");
        Workbook workbook = WorkbookFactory.create(file);

        // 获取要复制的Sheet页
        Sheet sheetToCopy = workbook.getSheet("Sheet1");

        // 复制Sheet页
        Sheet newSheet = workbook.createSheet("Copy of Sheet1");
        workbook.setSheetOrder(newSheet.getSheetName(), 0);
        CopySheetResult copyResult = workbook.cloneSheet(0);
        int newSheetIndex = copyResult.getNewSheet().getSheetIndex();

        // 复制Sheet页的样式和参数
        for (Row row : newSheet) {
            for (Cell cell : row) {
                CellStyle oldStyle = sheetToCopy.getRow(cell.getRowIndex()).getCell(cell.getColumnIndex()).getCellStyle();
                CellStyle newStyle = workbook.createCellStyle();
                newStyle.cloneStyleFrom(oldStyle);
                cell.setCellStyle(newStyle);

                Cell oldCell = sheetToCopy.getRow(cell.getRowIndex()).getCell(cell.getColumnIndex());
                Cell newCell = newSheet.getRow(cell.getRowIndex()).getCell(cell.getColumnIndex());
                newCell.setCellType(oldCell.getCellType());
                switch (oldCell.getCellType()) {
                    case STRING:
                        newCell.setCellValue(oldCell.getRichStringCellValue());
                        break;
                    case NUMERIC:
                        newCell.setCellValue(oldCell.getNumericCellValue());
                        break;
                    case BOOLEAN:
                        newCell.setCellValue(oldCell.getBooleanCellValue());
                        break;
                    case FORMULA:
                        newCell.setCellFormula(oldCell.getCellFormula());
                        break;
                    case BLANK:
                        newCell.setBlank();
                        break;
                    default:
                        break;
                }
            }
        }

        // 保存Excel文件
        FileOutputStream out = new FileOutputStream("output.xlsx");
        workbook.write(out);
        out.close();
        workbook.close();
        file.close();
    }
}

在这个示例中，我们首先复制Sheet页，并使用`CopySheetResult`对象来获取新Sheet页的索引。接下来，我们遍历新Sheet页中的所有单元格，并将其样式和参数设置为要复制的Sheet页中对应单元格的样式和参数。最后，我们保存Excel文件，并关闭相关的流。