关于Excel重复续写 about easyexcel HOT 5 CLOSED

public static void main(String[] args) {
    String exportFilePath = "E:\\LocalTest.xlsx";
    Integer baseIndex = 0;
    for (int index = 0; index < 3; index++) {
        doExport(exportFilePath, baseIndex);
        baseIndex = baseIndex + 10000;
    }
}

private static void doExport(String exportFilePath, Integer baseIndex) {
    List<Order> orderList = new ArrayList<>();
    for (int index = 0; index < 10000; index++) {
        Order order = new Order();
        order.setFOrderId("FOrderId" + index + baseIndex);
        order.setFMerchantId("FMerchantId" + index + baseIndex);
        order.setFUserName("FUserName" + index + baseIndex);
        order.setFState(new Random().nextInt(3));
        order.setFAmount(new Random().nextInt(1000000));
        order.setFRefundAmount(new Random().nextInt(1000000));
        order.setFGoodsType("FGoodsType" + index + baseIndex);
        order.setFGoodsName("FGoodsName" + index + baseIndex);
        order.setFGoodsDetail("FGoodsDetail" + index + baseIndex);
        order.setFTime(new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(new Date()));
        orderList.add(order);
    }
    EasyExcelUtil.export(exportFilePath, orderList, Order.class, ExcelTypeEnum.XLSX);
}

public static <T extends BaseMeta> void export(String exportFilePath, List<T> metaList, Class clazz, ExcelTypeEnum excelTypeEnum) {
    try {
        OutputStream outputStream = new FileOutputStream(exportFilePath);
        ExcelWriter excelWriter = new ExcelWriter(outputStream, excelTypeEnum);
        Sheet sheet1 = new Sheet(1, 0, clazz);
        excelWriter.write(metaList, sheet1);
        excelWriter.finish();
    } catch (FileNotFoundException exception) {
        System.out.println("EasyExcelUtil.export(), FileNotFoundException: " + exception);
    }
}