java读取excel格式数据

最新推荐文章于 2023-06-28 14:41:46 发布

xhcsh

最新推荐文章于 2023-06-28 14:41:46 发布

阅读量206

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/xhcsh/article/details/105579300

版权

java 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

工具类:
public class ExcelHelper {

    /**
     * @param inputStream      excel输入流
     * @param startRowIndex    开始行号
     * @param lastOfInvalidRow 忽略最后几行
     * @author hahaha
     * @Description
     * @since 2018/12/25 17:28
     **/
    public static List<List<Object>> importExcel(InputStream inputStream, int startRowIndex, int lastOfInvalidRow) {
        ExcelReader reader = ExcelUtil.getReader(inputStream);
        List<List<Object>> read = reader.read(startRowIndex);
        return read.subList(0, read.size() - lastOfInvalidRow);
    }

}

测试类:

public class Test {

/**
 *
 * @param inputStream
 *  TPtnRingLineEntity:任意自己创建存放数据的实体类
 * @return
 */
    public boolean importXNumber(InputStream inputStream) {
        List<List<Object>> list = ExcelHelper.importExcel(inputStream, 0, 0);
        List<TPtnRingLineEntity> tPtnRingLineEntities = new ArrayList<>();
        //处理所导入的excel表格的列名
        if (list != null && list.size() > 1) {
            list.remove(0);
            list.stream().forEach(list1 -> {
                int size = list1.size();
                TPtnRingLineEntity tPtnRingLineEntity = new TPtnRingLineEntity();
                tPtnRingLineEntity.setDeviceLevel(list1.get(0).toString());
                tPtnRingLineEntity.setPtnNames(list1.get(1).toString());
                tPtnRingLineEntity.setRingLine(list1.get(2).toString());
                tPtnRingLineEntities.add(tPtnRingLineEntity);
            });
        }
        //存库
//        tPtnRingLineRepository.deleteAll();
//        tPtnRingLineRepository.saveAll(tPtnRingLineEntities);
        return true;

    }

    public static void main(String[] args) {
        File file =new File("C:/Users/admin/Desktop/x.xlsx");
        try {

            InputStream in = new FileInputStream(file);
            Test test=new Test();
            test.importXNumber(in);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }
    }

}