一直很想写些什么东西,可以留着今后将来看看,可以回顾一下,所以现在开始我的mark历程了!
java excel导入,相信网上已经一大推东西了,我只是想分享下自己最近学到的。
首先excel导入,需要一个实体类模板:
package cn.zonesea.framework.common.excel;
public class TxlWatchRfidMapping {
@Excel(exportName = "RFID编号", exportFieldWidth = 32, exportConvertSign = 0, importConvertSign = 0)
private String RFID;
@Excel(exportName = "RFID名称", exportFieldWidth = 100, exportConvertSign = 0, importConvertSign = 0)
private String RFIDNAME;
@Excel(exportName = "使用类型", exportFieldWidth = 18, exportConvertSign = 0, importConvertSign = 0)
private Integer USETYPE;
@Excel(exportName = "描述", exportFieldWidth = 500, exportConvertSign = 0, importConvertSign = 0)
private String REMARK;
@Excel(exportName = "经度", exportFieldWidth = 500, exportConvertSign = 0, importConvertSign = 0)
private String LONGITUDE;
@Excel(exportName = "纬度", exportFieldWidth = 500, exportConvertSign = 0, importConvertSign = 0)
private String LATITUDE;
@Excel(exportName = "高度", exportFieldWidth = 500, exportConvertSign = 0, importConvertSign = 0)
private String HEIGHT;
@Excel(exportName = "人员姓名", exportFieldWidth = 500, exportConvertSign = 0, importConvertSign = 0)
private String USERNAME;
@Excel(exportName = "人员编号", exportFieldWidth = 500, exportConvertSign = 0, importConvertSign = 0)
private Long USERID;
private Integer CREATEUSER;
public String getRFID(