import pandas as pd

def split_excel_by_groups(input_file, output_prefix, group_column):
    """
    将Excel文件按指定列分组并保存为多个文件
    
    参数:
        input_file: 输入的Excel文件路径
        output_prefix: 输出文件的前缀
        group_column: 用于分组的列名
    """
    # 读取Excel文件
    df = pd.read_excel(input_file)
    
    # 按指定列分组
    grouped = df.groupby(group_column)
    
    # 为每个分组创建单独的文件
    for name, group in grouped:
        # 生成输出文件名
        output_file = f"{output_prefix}_{name}.xlsx"
        
        # 保存分组数据到新文件
        group.to_excel(output_file, index=False)
        print(f"已保存: {output_file}")

# 使用示例
split_excel_by_groups("input.xlsx", "output", "部门")

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

public class ExcelSplitter {
    public static void splitByColumn(String inputPath, String outputPrefix, int groupColumnIndex) throws IOException {
        try (InputStream is = new FileInputStream(inputPath);
             Workbook workbook = WorkbookFactory.create(is)) {
            
            Sheet sheet = workbook.getSheetAt(0);
            Map<Object, List<Row>> groups = new HashMap<>();
            
            // 分组数据
            for (Row row : sheet) {
                Cell groupCell = row.getCell(groupColumnIndex);
                Object groupKey = getCellValue(groupCell);
                groups.computeIfAbsent(groupKey, k -> new ArrayList<>()).add(row);
            }
            
            // 为每个分组创建新文件
            for (Map.Entry<Object, List<Row>> entry : groups.entrySet()) {
                String outputPath = outputPrefix + "_" + entry.getKey() + ".xlsx";
                try (Workbook newWorkbook = new XSSFWorkbook();
                     OutputStream os = new FileOutputStream(outputPath)) {
                    
                    Sheet newSheet = newWorkbook.createSheet();
                    for (Row row : entry.getValue()) {
                        Row newRow = newSheet.createRow(newSheet.getLastRowNum() + 1);
                        copyRow(row, newRow);
                    }
                    newWorkbook.write(os);
                }
            }
        }
    }
    
    private static Object getCellValue(Cell cell) {
        if (cell == null) return "";
        switch (cell.getCellType()) {
            case STRING: return cell.getStringCellValue();
            case NUMERIC: return cell.getNumericCellValue();
            case BOOLEAN: return cell.getBooleanCellValue();
            default: return "";
        }
    }
    
    private static void copyRow(Row source, Row target) {
        for (Cell cell : source) {
            Cell newCell = target.createCell(cell.getColumnIndex());
            switch (cell.getCellType()) {
                case STRING: newCell.setCellValue(cell.getStringCellValue()); break;
                case NUMERIC: newCell.setCellValue(cell.getNumericCellValue()); break;
                case BOOLEAN: newCell.setCellValue(cell.getBooleanCellValue()); break;
                case FORMULA: newCell.setCellFormula(cell.getCellFormula()); break;
            }
        }
    }
}

import re
safe_name = re.sub(r'[\\/*?:"<>|]', "_", str(name))