Apache POI -基于两个日期参数导出到Excel

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>

Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Sheet1");

Row headerRow = sheet.createRow(0);
headerRow.createCell(0).setCellValue("Start Date");
headerRow.createCell(1).setCellValue("End Date");

// 假设你有一个包含日期数据的列表
List<Date> dates = getData(startDate, endDate);

for (int i = 0; i < dates.size(); i++) {
    Row row = sheet.createRow(i + 1);
    Cell startDateCell = row.createCell(0);
    Cell endDateCell = row.createCell(1);
    
    startDateCell.setCellValue(dates.get(i));
    endDateCell.setCellValue(dates.get(i));
}

try (FileOutputStream outputStream = new FileOutputStream("output.xlsx")) {
    workbook.write(outputStream);
}