cn.joylau.office.excel.ExcelIO 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;


import cn.joylau.office.excel.api.poi.POIExcelApi;
import cn.joylau.office.excel.config.ExcelWriterConfig;
import cn.joylau.office.excel.config.Header;
import cn.joylau.office.excel.support.CommonExcelReader;
import cn.joylau.office.excel.support.CommonExcelWriter;
import cn.joylau.office.excel.support.template.TemplateExcelWriter4POI;
import cn.joylau.office.excel.support.template.expression.CommonCellHelper;
import cn.joylau.office.excel.support.template.expression.ExpressionRunner;
import cn.joylau.office.excel.support.template.expression.GroovyExpressionRunner;
import cn.joylau.office.excel.wrapper.BeanWrapper;
import cn.joylau.office.excel.wrapper.HashMapWrapper;
import cn.joylau.office.excel.wrapper.MultitermSheetWrapper;

import java.io.InputStream;
import java.io.OutputStream;
import java.util.Arrays;
import java.util.List;
import java.util.Map;

/**
 * Excel读写操作类
 */
public class ExcelIO {

    /**
     * 读取excel为map集合
     *
     * @param inputStream excel输入流
     * @return map对象集合
     * @throws Exception 读取异常
     */
    public static List> read2Map(InputStream inputStream) throws Exception {
        return read(inputStream, new HashMapWrapper());
    }

    public static List>> read2MulMap(InputStream inputStream) throws Exception {
        HashMapWrapper[] wrapper = {new HashMapWrapper()};
        return (List) read(inputStream, wrapper);
    }

    /**
     * 读取excel为javaBean
     *
     * @param inputStream  excel输入流
     * @param headerMapper 表头与字段映射配置
     * @param           bean泛型
     * @param tClass       javaBean类型
     * @return bean集合
     * @throws Exception 读取异常
     */
    public static  List read2Bean(InputStream inputStream, Map headerMapper, Class tClass) throws Exception {
        BeanWrapper wrapper = new BeanWrapper();
        wrapper.setType(tClass);
        wrapper.setHeaderNameMapper(headerMapper);
        return read(inputStream, wrapper);
    }

    /**
     * 自定义包装器读取excel为集合
     *
     * @param inputStream excel输入流
     * @param wrapper     包装器
     * @param          读取结果泛型
     * @return 读取结果集合
     * @throws Exception 读取异常
     */
    public static  List read(InputStream inputStream, ExcelReaderWrapper wrapper) throws Exception {
        CommonExcelReader reader = new CommonExcelReader();
        reader.setWrapper(wrapper);
        return reader.readExcel(inputStream);
    }

    /**
     * 读取多个sheet为多个list
     *
     * @param inputStream excel输入流
     * @param wrappers    包装器
     * @return 读取结果
     * @throws Exception
     */
    public static List read(InputStream inputStream, ExcelReaderWrapper[] wrappers) throws Exception {
        CommonExcelReader reader = new CommonExcelReader();
        MultitermSheetWrapper wrapper = new MultitermSheetWrapper(wrappers);
        reader.setWrapper(wrapper);
        reader.readExcel(inputStream);
        return wrapper.getData();
    }


    /**
     * 写出简单格式excel,第一行为表头,依次为数据
     *
     * @param outputStream 输出流
     * @param headers      表头信息
     * @param dataList     数据集合
     * @throws Exception
     */
    public static void write(OutputStream outputStream, List headers, List