erp / tax-agent · Files

package com.diligrp.tax.adopt.util;

import com.diligrp.tax.central.exception.TaxAgentServiceException;
import com.diligrp.tax.central.type.TaxSystemType;
import org.apache.poi.ss.usermodel.Workbook;

import java.util.*;

/**
 * @Author: zhangmeiyang
 * @CreateTime: 2025-11-19 15:11
 * @Version: todo
 */
public class ExcelUtils {
    public static List<Map<String, Object>> processSheet(Workbook book) {
        var res = new ArrayList<Map<String, Object>>();
        Optional.ofNullable(book).orElseThrow(() -> new TaxAgentServiceException(TaxSystemType.ABNORMAL_PARAMETERS, "文件转换异常"));
        book.sheetIterator().forEachRemaining(sheet -> sheet.rowIterator().forEachRemaining(row -> {
            var map = new HashMap<String, Object>();
            row.cellIterator().forEachRemaining(cell -> map.put(cell.getStringCellValue(), cell.getStringCellValue()));
            res.add(map);
        }));
        return res;
    }
}