poi 对excel的读写(跟着宝哥学java)

1 导入依赖

org.apache.poi

poi

4.0.0

org.apache.poi

poi-ooxml

4.0.0

2 创建实体类

package com.zhiyou100.entity;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

import org.hibernate.annotations.GenericGenerator;

import javax.persistence.*;

import java.io.Serializable;

@Entity

@Table(name="table_student")

@Data

@AllArgsConstructor

@NoArgsConstructor

public class Student implements Serializable {

@Id

@Column(name="s_id")

@GenericGenerator(name = "sg",strategy = "increment")

@GeneratedValue(generator = "sg")

private Integer id;

@Column(name = "s_name",unique = true,nullable = false)

private String name;

@Column(name = "s_sex",nullable = false)

private String sex;

@Column(name = "s_score",nullable = false)

private Float score;

@Column(name = "s_dy",nullable = false)

private Boolean dy;

}

3 创建poi工具类

package com.zhiyou100.util;

import java.io.File;

import java.io.FileInputStream;

import java.io.InputStream;

import java.lang.reflect.Field;

import java.util.*;

import com.zhiyou100.entity.Student;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.CellType;

public class PoiUtil{

public static void main(String[] args) throws Exception{

List list=new ArrayList<>();

// for (int i=0;i<=10;i++){

// list.add(new Student(

// (int)(Math.random()*10000),

// UUID.randomUUID().toString().replace("-",""),

// Math.random()>0.5?"男":"女",

// (int)(Math.random()*1000)/10.0f,

// Math.random()>0.5));

// }

// new PoiUtil().createExcel(list,"d:\\");

list=new PoiUtil().readExcel(new FileInputStream("d:\\Student.xls"),new Student());

System.out.println(list);

}

//创建excel文件

//public static void createExcel(List