如何使用Apache POI对XSSFTable列启用排序/过滤？

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTable;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSortState;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.STDataConsolidateFunction;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableColumn;

Workbook workbook = new XSSFWorkbook("path/to/excel.xlsx");
Sheet sheet = workbook.getSheetAt(0);
XSSFTable table = (XSSFTable) sheet.getTables().get(0);

CTTable cttable = table.getCTTable();
CTSortState sortState = cttable.getSortState();
if (sortState == null) {
    sortState = cttable.addNewSortState();
}

// 设置排序列，默认升序
CTTableColumn sortColumn = sortState.addNewSortCondition();
sortColumn.setDxfId(0); // 设置排序样式，默认为0
sortColumn.setColumnName("ColumnName"); // 设置排序的列名
sortColumn.setDataColumnType(STDataConsolidateFunction.Enum.forInt(0)); // 设置排序数据类型，默认为0

// 设置过滤列
CTTableColumn filterColumn = sortState.addNewSortCondition();
filterColumn.setDxfId(0); // 设置过滤样式，默认为0
filterColumn.setColumnName("ColumnName"); // 设置过滤的列名
filterColumn.setDataColumnType(STDataConsolidateFunction.Enum.forInt(0)); // 设置过滤数据类型，默认为0

table.updateReferences();

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTable;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSortState;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.STDataConsolidateFunction;
import org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableColumn;

import java.io.FileInputStream;
import java.io.IOException;

public class XSSFTableSortFilterExample {
    public static void main(String[] args) {
        try {
            // 加载Excel文件
            FileInputStream file = new FileInputStream("path/to/excel.xlsx");
            Workbook workbook = new XSSFWorkbook(file);
            Sheet sheet = workbook.getSheetAt(0);
            XSSFTable table = (XSSFTable) sheet.getTables().get(0);
            
            // 获取排序/过滤状态对象
            CTTable cttable = table.getCTTable();
            CTSortState sortState = cttable.getSortState();
            if (sortState == null) {
                sortState = cttable.addNewSortState();
            }
            
            // 设置排序条件
            CTTableColumn sortColumn = sortState.addNewSortCondition();
            sortColumn.setDxfId(0);
            sortColumn.setColumnName("ColumnName");
            sortColumn.setDataColumnType(STDataConsolidateFunction.Enum.forInt(0));
            
            // 设置过滤条件
            CTTableColumn filterColumn = sortState.addNewSortCondition();
            filterColumn.setDxfId(0);
            filterColumn.setColumnName("ColumnName");
            filterColumn.setDataColumnType(STDataConsolidateFunction.Enum.forInt(0));
            
            // 应用排序/过滤操作到表格
            table.updateReferences();
            
            // 保存修改后的Excel文件
            FileOutputStream outFile = new FileOutputStream("path/to/excel.xlsx");
            workbook.write(outFile);
            outFile.close();
            
            // 关闭文件流
            file.close();
            System.out.println("Sorting/Filtering of XSSFTable columns completed successfully.");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}