jsp选中导出excel源码

<%@ page import="org.apache.poi.ss.usermodel.*, org.apache.poi.xssf.usermodel.XSSFWorkbook" %>
<%@ page import="java.io.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Export to Excel</title>
</head>
<body>
<%
    // 创建一个新的工作簿
    Workbook workbook = new XSSFWorkbook();
    Sheet sheet = workbook.createSheet("Sample Data");

    // 创建一些示例数据
    Object[][] data = {
        {"Name", "Age", "Email"},
        {"John Doe", 30, "john.doe@example.com"},
        {"Jane Smith", 25, "jane.smith@example.com"}
    };

    // 将数据写入工作表
    int rowNum = 0;
    for (Object[] rowData : data) {
        Row row = sheet.createRow(rowNum++);
        int colNum = 0;
        for (Object field : rowData) {
            Cell cell = row.createCell(colNum++);
            if (field instanceof String) {
                cell.setCellValue((String) field);
            } else if (field instanceof Integer) {
                cell.setCellValue((Integer) field);
            }
        }
    }

    // 设置响应头以下载文件
    response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
    response.setHeader("Content-Disposition", "attachment; filename=sample.xlsx");

    // 将工作簿写入响应输出流
    try (OutputStream outputStream = response.getOutputStream()) {
        workbook.write(outputStream);
    } catch (IOException e) {
        e.printStackTrace();
    }
%>
</body>
</html>