struts2 解析上传的Excel

来源：互联网发布：阿里云linux中文乱码编辑：程序博客网时间：2024/06/05 15:52
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 "";}}
0 0