java代码导出excel多个Sheet

Java代码可以使用Apache POI库来导出多个Sheet的Excel文件。下面是一个示例代码：

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;
import java.io.IOException;

public class ExcelExporter {
    public static void main(String[] args) {
        try (Workbook workbook = new XSSFWorkbook()) {
            createSheet1(workbook);
            createSheet2(workbook);
            createSheet3(workbook);
            
            // 保存Excel文件
            try (FileOutputStream outputStream = new FileOutputStream("output.xlsx")) {
                workbook.write(outputStream);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static void createSheet1(Workbook workbook) {
        Sheet sheet = workbook.createSheet("Sheet1");

        // 创建表头行
        Row headerRow = sheet.createRow(0);
        Cell headerCell1 = headerRow.createCell(0);
        headerCell1.setCellValue("Name");
        Cell headerCell2 = headerRow.createCell(1);
        headerCell2.setCellValue("Age");

        // 创建数据行
        Row dataRow1 = sheet.createRow(1);
        Cell dataCell1 = dataRow1.createCell(0);
        dataCell1.setCellValue("John");
        Cell dataCell2 = dataRow1.createCell(1);
        dataCell2.setCellValue(30);

        Row dataRow2 = sheet.createRow(2);
        Cell dataCell3 = dataRow2.createCell(0);
        dataCell3.setCellValue("Jane");
        Cell dataCell4 = dataRow2.createCell(1);
        dataCell4.setCellValue(25);
    }

    private static void createSheet2(Workbook workbook) {
        Sheet sheet = workbook.createSheet("Sheet2");

        // 创建表头行
        Row headerRow = sheet.createRow(0);
        Cell headerCell1 = headerRow.createCell(0);
        headerCell1.setCellValue("City");
        Cell headerCell2 = headerRow.createCell(1);
        headerCell2.setCellValue("Population");

        // 创建数据行
        Row dataRow1 = sheet.createRow(1);
        Cell dataCell1 = dataRow1.createCell(0);
        dataCell1.setCellValue("New York");
        Cell dataCell2 = dataRow1.createCell(1);
        dataCell2.setCellValue(8622698);

        Row dataRow2 = sheet.createRow(2);
        Cell dataCell3 = dataRow2.createCell(0);
        dataCell3.setCellValue("Los Angeles");
        Cell dataCell4 = dataRow2.createCell(1);
        dataCell4.setCellValue(3990456);
    }

    private static void createSheet3(Workbook workbook) {
        Sheet sheet = workbook.createSheet("Sheet3");

        // 创建表头行
        Row headerRow = sheet.createRow(0);
        Cell headerCell1 = headerRow.createCell(0);
        headerCell1.setCellValue("Product");
        Cell headerCell2 = headerRow.createCell(1);
        headerCell2.setCellValue("Price");

        // 创建数据行
        Row dataRow1 = sheet.createRow(1);
        Cell dataCell1 = dataRow1.createCell(0);
        dataCell1.setCellValue("iPhone");
        Cell dataCell2 = dataRow1.createCell(1);
        dataCell2.setCellValue(999.99);

        Row dataRow2 = sheet.createRow(2);
        Cell dataCell3 = dataRow2.createCell(0);
        dataCell3.setCellValue("Samsung Galaxy");
        Cell dataCell4 = dataRow2.createCell(1);
        dataCell4.setCellValue(899.99);
    }
}

以上代码创建了一个包含三个Sheet的Excel文件，每个Sheet都有不同的表头和数据。最后，将Excel文件保存为"output.xlsx"