import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
import com.picc.claimsource.excel.annotation.Excel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class ExcelDaoVo implements Serializable {
private static final long serialVersionUID = 1L;
/** 对应字段:id,备注:主键id */
@ApiModelProperty("主键id")
@JsonSerialize(using= ToStringSerializer.class)
private Long userid;
/** 对应字段:grade,备注:角色 */
@ApiModelProperty("角色")
@Excel( name="角色", width=15 )
private String grade;
/** 对应字段:user_name,备注:用户姓名 */
@ApiModelProperty("用户姓名")
@Excel( name="姓名", width=15 )
private String username;
/** 对应字段:password,备注:用户密码 */
@ApiModelProperty("用户密码")
@Excel( name="密码", width=15 )
private String password;
/** 对应字段:identifyNumber,备注:身份证号 */
@ApiModelProperty("身份证号")
@Excel( name="身份证号", width=15 )
private String identifyNumber;
/** 对应字段:mobile,备注:手机号 */
@ApiModelProperty("手机号")
@Excel( name="电话", width=15 )
private String mobile;
/** 对应字段:email,备注:邮箱 */
@ApiModelProperty("邮箱")
@Excel( name="邮箱", width=15 )
private String email;
}
这是vo类,@Excel里面的name就是excel表的表头
File toFile =new File ( "" );
InputStream is=new FileInputStream ( toFile );
ExcelUtil <ExcelDaoVo> util=new ExcelUtil <> ( ExcelDaoVo.class );
List <ExcelDaoVo> userList=util.importExcel ( is );
里面具体的一些类在https://download.csdn.net/download/weixin_45887234/86439150 ,这里面是具体的类,太多了,不好写