com.gitee.beiding.template_excel.TemplateCellParseUtils Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of template-excel Show documentation
使用模板快速提取excel文件中的数据为数据实体,或者使用模板将数据实体渲染成excel
There is a newer version: 3.18.1-RELEASE
package com.gitee.beiding.template_excel;

import java.util.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

class TemplateCellParseUtils {

    private static Pattern ARRAY_PATTERN = Pattern.compile("\\[([^\\[\\]]+)]");

    static class Result {

        private LinkedHashMap> checkJsMap;

        LinkedHashMap> getCheckJsMap() {
            return checkJsMap;
        }

        private String expression;

        String getExpression() {
            return expression;
        }

        private List commands;

        List getCommands() {
            return commands;
        }
    }

    //表达式${xxx}
    private static Pattern EXPRESSION_PATTERN = Pattern.compile("\\$\\{([^{}]*)}");

    private static String handleExpression(String s) {

        Matcher matcher = EXPRESSION_PATTERN.matcher(s);

        int end = 0;

        List all = new LinkedList<>();
        while (matcher.find()) {
            if (matcher.start() > end) {


                String st = "'" + s.substring(end, matcher.start()).replace("'", "\\\'") + "'";
                all.add(st);
            }
            String group = matcher.group(1);
            all.add(group);
            end = matcher.end();
        }

        if (all.size() > 0) {
            if (end < s.length() - 1) {
                all.add("'" + s.substring(end).replace("'", "\\\\'") + "'");
            }
            String join = StringUtils.join(',', all);

            return "concat(" + join + ")";
        } else {
            return "'" + s + "'";
        }
    }

    private static Pattern command_patten = Pattern.compile("\\$[a-zA-Z][a-zA-Z0-9]*\\([a-zA-Z0-9,_ ]*\\)");

    private static void handleCommand(String s, Result result) {
        Matcher matcher = command_patten.matcher(s);
        if (matcher.find()) {
            result.commands = new ArrayList<>();
            result.commands.add(matcher.group());
            while (matcher.find()) {
                if (!result.commands.contains(matcher.group())) {
                    result.commands.add(matcher.group());
                }
            }
        }
    }


    /*
        变换数组
     */

    //提取数组引用
    static Result parse(String s) {//提取并变换数组表达式

        //替换掉换行符
        s = s.replace("\n", "\\n");

        Result result = new Result();

        StringUtils.StringRecover extract = StringUtils.extract(s);

        s = extract.getResult();


        //提取指令
        handleCommand(s, result);

        s = handleExpression(s);

        result.checkJsMap = new LinkedHashMap<>();

        Matcher matcher = ARRAY_PATTERN.matcher(s);


        //从表达式中查找数组元素
        while (matcher.find()) {

           // System.out.println(s);

            //表达式字符串
            String exp = "";

         //   System.out.println(matcher.group());

            int end = matcher.start() - 1;

            while (true) {
                //反向查找成对的中括号
                StringUtils.SubStringResult reverse = StringUtils.pairingSubStringReverse(s, end, ']', '[');

                if (reverse != null && reverse.endEqualsFrom()) {

                    //向前做一次推移
                    end = reverse.getStart() - 1;

                    //构建表达式
                    exp = reverse.getSubString() + exp;

                } else {//跳出循环
                    break;
                }
            }


            //判断是否是一个函数
            StringUtils.SubStringResult reverse = StringUtils.pairingSubStringReverse(s, end, ')', '(');
            if (reverse != null && reverse.endEqualsFrom()) {
                end = reverse.getStart() - 1;
                exp = reverse.getSubString() + exp;
            }

            //反向查找,一定具有,或者(
            reverse = StringUtils.findCharSubStringReverse(s, end, ',', '(');



            if (reverse != null && reverse.endEqualsFrom()) {



               // end = reverse.getStart() - 1;
                exp = reverse.getSubString() + exp;
                String h = exp;
                String group1 = matcher.group(1);
                LinkedHashSet linkedHashSet = result.checkJsMap.computeIfAbsent(group1, k -> new LinkedHashSet<>());
                String js = h + "&&" + h + ".length" + "&&" + h + ".length>" + group1 + "?false:true;";//返回是否已经超出预期值

                linkedHashSet.add(extract.recover(js));

            }
        }

      //  System.out.println(result.checkJsMap);


        result.expression = extract.recover(s);

        if (result.getCommands() != null) {
            List cs = new ArrayList<>();
            for (String command : result.getCommands()) {
                cs.add(extract.recover(command));
            }
            result.commands = cs;
        }

        return result;

    }

}