public class up{
/**
* 上传的excel文件
*/
private File excelFile;
/**
* 文件带后缀的名称
*/
private String excelFileFileName;
/**
* 文件的类型后缀
*/
private String excelFileContentType;
public File getExcelFile() {
return excelFile;
}
public void setExcelFile(File excelFile) {
this.excelFile = excelFile;
}
public String getExcelFileFileName() {
return excelFileFileName;
}
public void setExcelFileFileName(String excelFileFileName) {
this.excelFileFileName = excelFileFileName;
}
public String getExcelFileContentType() {
return excelFileContentType;
}
public void setExcelFileContentType(String excelFileContentType) {
this.excelFileContentType = excelFileContentType;
}
public String shopUpload() {
String ext = excelFileFileName.substring(excelFileFileName.indexOf("."), excelFileFileName.length());
if (ext.equals(".xls")) {
List<List> list_sheet = ExcelFileUtil.readExcel(excelFile);
if (null != list_sheet && list_sheet.size() > 0) {
List list_s = (List) list_sheet.get(0);// 取得第1页 只取1页
for (int i = 0; i < list_s.size(); i++) {
System.out.println(i);
List r = (List) list_s.get(i); // 取得第 i 行
TbExcelDetail tbd = new TbExcelDetail();
// 有行空白数据
if (r.get(0).toString() == "" && r.get(2).toString() == "" && r.get(5).toString() == "" && r.get(6).toString() == "" && r.get(1).toString() == "") {
continue;
}
tbd.setIsbn(r.get(0).toString());
tbd.setBookName(r.get(1).toString() == "" ? "" : r.get(1).toString());
tbd.setPrice(r.get(2).toString() == "" ? "" : r.get(2).toString());
tbd.setStockNum(r.get(3).toString() == "" ? "" : r.get(3).toString());
tbd.setShopcat(r.get(4).toString() == "" ? "" : r.get(4).toString());
if ("" != r.get(5).toString()) {
Integer sid = Integer.parseInt(r.get(5).toString());
tbd.setSouceId(sid);
}
if ("" != r.get(6).toString() && !r.get(6).toString().equals("NULL")) {
Integer wlid = Integer.parseInt(r.get(6).toString());
tbd.setWlId(wlid);
}
tbd.setDiscount(r.get(7).toString() == "" ? "" : r.get(7).toString());
if(r.get(6).toString().equals("NULL")){
continue;
}
list.add(tbd);
}
}
}
return "";
}
}
struts2 解析上传的Excel
最新推荐文章于 2021-04-05 12:20:31 发布