在PrimeFaces中导出p:数据表到excel

<dependency>
    <groupId>org.primefaces</groupId>
    <artifactId>primefaces</artifactId>
    <version>版本号</version>
</dependency>

<p:dataTable value="#{bean.dataList}" var="data" paginator="true" rows="10">
    <!-- 列定义 -->
    <p:column headerText="列1">
        #{data.column1}
    </p:column>
    <p:column headerText="列2">
        #{data.column2}
    </p:column>
    <!-- 更多列 -->
</p:dataTable>

<p:commandButton value="导出到Excel" ajax="false" actionListener="#{bean.exportToExcel}" />

import org.primefaces.model.DefaultStreamedContent;
import org.primefaces.model.StreamedContent;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.io.Serializable;

@ManagedBean
@ViewScoped
public class Bean implements Serializable {
    private List<Data> dataList; // 数据列表

    // getter和setter方法

    public void exportToExcel() {
        // 创建Excel工作簿
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("数据表");

        // 创建表头
        Row headerRow = sheet.createRow(0);
        headerRow.createCell(0).setCellValue("列1");
        headerRow.createCell(1).setCellValue("列2");
        // 更多列

        // 填充数据
        for (int i = 0; i < dataList.size(); i++) {
            Row dataRow = sheet.createRow(i + 1);
            Data data = dataList.get(i);
            dataRow.createCell(0).setCellValue(data.getColumn1());
            dataRow.createCell(1).setCellValue(data.getColumn2());
            // 更多列
        }

        // 将Excel写入字节数组输出流
        ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
        try {
            workbook.write(outputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }

        // 创建导出的Excel文件流
        InputStream inputStream = new ByteArrayInputStream(outputStream.toByteArray());
        StreamedContent file = new DefaultStreamedContent(inputStream, "application/vnd.ms-excel", "data.xlsx");

        // 下载导出的Excel文件
        FacesContext context = FacesContext.getCurrentInstance();
        ExternalContext externalContext = context.getExternalContext();
        externalContext.setResponseContentType(file.getContentType());
        externalContext.setResponseHeader("Content-Disposition", "attachment;filename=\"" + file.getName() + "\"");

        try (OutputStream outputStream = externalContext.getResponseOutputStream()) {
            byte[] buffer = new byte[1024];
            int length;
            while ((length = inputStream.read(buffer)) > 0) {
                outputStream.write(buffer, 0, length);
            }
            outputStream.flush();
        } catch (IOException e) {
            e.printStackTrace();
        }

        context.responseComplete();
    }
}