// 创建一个新的Excel文档
Workbook workbook = new XSSFWorkbook();

• 1.
• 2.

// 创建一个工作表
Sheet sheet = workbook.createSheet("Sheet1");

// 创建一行
Row row = sheet.createRow(0);

// 创建单元格并写入数据
Cell cell = row.createCell(0);
cell.setCellValue("姓名");

// 继续创建单元格并写入其他数据...

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.
• 9.
• 10.
• 11.

// 将Excel文档写入输出流
ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
workbook.write(outputStream);

• 1.
• 2.
• 3.

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

// 将Excel文件流写入响应体
response.getOutputStream().write(outputStream.toByteArray());

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.

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

import javax.servlet.http.HttpServletResponse;
import java.io.ByteArrayOutputStream;
import java.io.IOException;

public class ExcelExporter {

    public void exportData(HttpServletResponse response) throws IOException {
        // 准备数据
        String[] headers = {"姓名", "年龄", "性别"};
        Object[][] data = {{"张三", 20, "男"}, {"李四", 25, "女"}};

        // 创建一个新的Excel文档
        Workbook workbook = new XSSFWorkbook();

        // 创建一个工作表
        Sheet sheet = workbook.createSheet("Sheet1");

        // 写入表头
        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.length; i++) {
            Row row = sheet.createRow(i + 1);
            for (int j = 0; j < data[i].length; j++) {
                Cell cell = row.createCell(j);
                cell.setCellValue(data[i][j].toString());
            }
        }

        // 将Excel文档写入输出流
        ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
        workbook.write(outputStream);

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

        // 将Excel文件流写入响应体
        response.getOutputStream().write(outputStream.toByteArray());
    }
}

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.
• 9.
• 10.
• 11.
• 12.
• 13.
• 14.
• 15.
• 16.
• 17.
• 18.
• 19.
• 20.
• 21.
• 22.
• 23.
• 24.
• 25.
• 26.
• 27.
• 28.
• 29.
• 30.
• 31.
• 32.
• 33.
• 34.
• 35.
• 36.
• 37.
• 38.
• 39.
• 40.
• 41.
• 42.
• 43.
• 44.
• 45.
• 46.
• 47.
• 48.