【Java EasyExcel】自定义处理器

最新推荐文章于 2025-03-31 00:00:00 发布

字节尚未跳动

最新推荐文章于 2025-03-31 00:00:00 发布

阅读量897

点赞数 3

文章标签： java 算法开发语言

本文链接：https://blog.youkuaiyun.com/m0_65563175/article/details/138767824

版权

工具类

public class ExcelUtils {

    public static void setValidation(Sheet sheet, DataValidationHelper helper,
                                     DataValidationConstraint constraint,
                                     CellRangeAddressList addressList,
                                     String msgHead, String msgContext) {
        DataValidation dataValidation = helper.createValidation(constraint, addressList);
        dataValidation.setErrorStyle(DataValidation.ErrorStyle.STOP);
        dataValidation.setShowErrorBox(true);
        dataValidation.setSuppressDropDownArrow(true);
        dataValidation.createErrorBox(msgHead, msgContext);
        sheet.addValidationData(dataValidation);
    }

    public static String getRange(Integer offset, Integer rowId, Integer colCount) {
        char start = (char) ('A' + offset);
        if (colCount <= 25) {
            char end = (char) (start + colCount - 1);
            return "$" + start + "$" + rowId + ":$" + end + "$" + rowId;
        }
        char endPrefix = 'A';
        char endSuffix = 'A';
        // 26-51之间，包括边界（仅两次字母表计算）或者是51以上
        if ((colCount - 25) / 26 == 0 || colCount == 51) {
            // 边界值
            if ((colCount - 25) % 26 == 0) {
                endSuffix = (char) ('A' + 25);
            } else {
                endSuffix = (char) ('A' + (colCount - 25) % 26 -

最低0.47元/天解锁文章