Java excel导出工具类

以下是一个简单的 Java Excel 导出工具类的示例，可以使用 Apache POI 库来实现：

import java.io.FileOutputStream;
import java.io.IOException;
import java.util.List;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelExportUtil {

    public static void export(List<Object[]> data, String[] headers, String sheetName, String filePath) throws IOException {
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet(sheetName);

        // 设置表头
        Row headerRow = sheet.createRow(0);
        for (int i = 0; i < headers.length; i++) {
            Cell cell = headerRow.createCell(i);
            cell.setCellValue(headers[i]);
        }

        // 写入数据
        for (int i = 0; i < data.size(); i++) {
            Object[] rowData = data.get(i);
            Row row = sheet.createRow(i + 1);
            for (int j = 0; j < rowData.length; j++) {
                Cell cell = row.createCell(j);
                cell.setCellValue(rowData[j].toString());
            }
        }

        // 保存文件
        try (FileOutputStream outputStream = new FileOutputStream(filePath)) {
            workbook.write(outputStream);
        }
    }

}

使用示例：

List<Object[]> data = new ArrayList<>();
data.add(new Object[] { "Tom", 18 });
data.add(new Object[] { "Jerry", 20 });

String[] headers = { "Name", "Age" };
String sheetName = "Sheet1";
String filePath = "D:/data.xlsx";

ExcelExportUtil.export(data, headers, sheetName, filePath);

该工具类可以将数据列表写入 Excel 文件中，并指定表头、工作表名称和文件路径。