cn.joylau.office.excel.support.template.reader.TemplateExcelReader Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of joylau-office Show documentation
Excel and Word Tools
The newest version!
/*******************************************************************************
 * Copyright (c) 2017 by JoyLau. All rights reserved
 ******************************************************************************/

package cn.joylau.office.excel.support.template.reader;


import cn.joylau.office.excel.config.AbstractExcelReaderCallBack;
import cn.joylau.office.excel.support.CommonExcelReader;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

public class TemplateExcelReader extends CommonExcelReader {

    private InputStream template;

    private List> templateInfo = new ArrayList<>();

    protected void parseConfig() throws Exception {
        api.read(template, new AbstractExcelReaderCallBack() {
            int nowRow = -1;
            List tmp = null;

            @Override
            public void onCell(CellContent content) throws Exception {
                if (nowRow != content.getRow()) {
                    nowRow = content.getRow();
                    if (tmp != null)
                        templateInfo.add(tmp);
                    tmp = new ArrayList<>();
                }
                Expression expression = new Expression();
                expression.setText(String.valueOf(content.getValue()));
                expression.setColumn(content.getColumn());
                expression.setRow(content.getRow());
                tmp.add(expression);
            }

            @Override
            public void done(Object workBook) {
                //添加最后一行
                templateInfo.add(tmp);
            }
        });
    }

    public void setTemplate(InputStream template) {
        this.template = template;
    }

    public static class Expression {
        private String text;

        private int row;
        private int column;

        public String getText() {
            return text;
        }

        public void setText(String text) {
            this.text = text;
        }

        public int getRow() {
            return row;
        }

        public void setRow(int row) {
            this.row = row;
        }

        public int getColumn() {
            return column;
        }

        public void setColumn(int column) {
            this.column = column;
        }

        @Override
        public String toString() {
            return "{" +
                    "text='" + text + '\'' +
                    ", row=" + row +
                    ", column=" + column +
                    '}';
        }

        enum TYPE {
            M,
            F,
            E,
            LIST
        }
    }
}