Java 读取本地 Excel 文件-蒲公英云

Java 读取本地 Excel 文件

GAV 坐标

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.1</version>
</dependency>

测试类

Order.class

package cn.me.es;

import lombok.Data;

/* @author yanyg @since 2020/9/3 /
@Data
public class Order {

String wayBillNo;
String name;
String phone;
String province;
String city;
String county;
String address;

}

ReadExcelUtils.class

package cn.me.es;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
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.io.InputStream;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.List;

public class ReadExcelUtils { 
    //XSSF -- 提供读写Microsoft Excel OOXML格式档案的功能
    //XSSFWorkbook:是操作Excel2007（以上）的版本，扩展名是.xlsx
    public static List<Order> read2007Xlsx(InputStream in) throws IOException, InvalidFormatException, ParseException { 
        List<Order> list = new ArrayList<>();
        XSSFWorkbook xWorkbook = new XSSFWorkbook(in);
        // Read the Sheet
        XSSFSheet xssfSheet = xWorkbook.getSheetAt(0);
        // Read the Row
        for (int rowNum = 1; rowNum <= xssfSheet.getLastRowNum(); rowNum++) { 
            XSSFRow xssfRow = xssfSheet.getRow(rowNum);
            if (xssfRow != null) { 
                Order order =new Order();
                // 单元格从 0 开始
                order.setWayBillNo(xssfRow.getCell(0).getStringCellValue());
                order.setName(xssfRow.getCell(1).getStringCellValue());
                order.setPhone(xssfRow.getCell(2).getStringCellValue());
                order.setProvince(xssfRow.getCell(3).getStringCellValue());
                order.setCity(xssfRow.getCell(4).getStringCellValue());
                order.setCounty(xssfRow.getCell(5).getStringCellValue());
                order.setAddress(xssfRow.getCell(6).getStringCellValue());
                list.add(order);
            }
        }
        xWorkbook.close();
        return list;
    }
    public static void main(String[] args) throws InvalidFormatException, IOException, ParseException { 
        String fullFileName = "D:\\41473.xlsx";
        InputStream is = new FileInputStream(fullFileName);
        List<Order> list = read2007Xlsx(is);
        System.out.println("size==>" + list.size());
        // 获取resource目录下的 41473.xlsx 文件:
// String resource = "41473.xlsx";
// ClassPathResource classPathResource = new ClassPathResource(resource);
// List<Order> list = read2007Xlsx(classPathResource.getInputStream());
// System.out.println("size==>" + list.size());
    }
}