常用工具(五) --解析Excel表格的工具类

解析Excel表格的工具类

<!--用于解析Excel表格的工具类-->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.8</version>
</dependency>

import bigdata.itcast.cn.es.bean.EsArticle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class ExcelParseUtil {
    
    public static List<EsArticle> parseExcel(String path) throws IOException {
        //构建返回的对象
        List<EsArticle> esArticles = new ArrayList<>();
        //实现解析
        FileInputStream inputStream = new FileInputStream(path);
        XSSFWorkbook sheets = new XSSFWorkbook(inputStream);
        //获取第一张表
        XSSFSheet sheet = sheets.getSheetAt(0);
        //获取表格最后一条数据的下标
        int lastRowNum = sheet.getLastRowNum();
        //取出每一条
        for(int i = 1;i<=lastRowNum ;i++){
            XSSFRow row = sheet.getRow(i);
            //取出每个字段
            String id = row.getCell(0).toString();
            String title = row.getCell(1).toString();
            String from = row.getCell(2).toString();
            String time = row.getCell(3).toString();
            String readCount = row.getCell(4).toString();
            String content = row.getCell(5).toString();
            //构建成JavaBean
            EsArticle esArticle = new EsArticle(id, title, from, time, readCount, content);
            //放入集合
            esArticles.add(esArticle);
        }
        //返回
        return  esArticles;
    }
}