工作中很多批量上傳需求不同，每個(gè)需求都要寫一次批量上傳代碼，太煩。。決定寫一個(gè)通用工具，此代碼復(fù)制即用。需要改進(jìn)的地方請(qǐng)?jiān)u論區(qū)留言

方法調(diào)用傳參例子：
上傳文件中列的字段對(duì)應(yīng)的是對(duì)象的屬性
String[] fieldsName = new String[]{"carModelName","salePrice"};

此參數(shù)是上傳文件中列必傳字段對(duì)應(yīng)對(duì)象的屬性
String[] fieldsIsNull = new String[]{"carModelName"};

注：數(shù)組屬性順序必須和文件中順序一樣，解析文件時(shí)賦值不會(huì)賦錯(cuò)字段

public static final String OFFICE_EXCEL_2003_POSTFIX = "xls"; public static final String OFFICE_EXCEL_2007_POSTFIX = "xlsx"; public static final String EMPTY = ""; public static final String POINT = ".";

/
**

* 通過(guò)反射處理以獲得的數(shù)據(jù)* @param*/ public T reflectDeal(T className, Cell cell, String fieldName){Class aClass = null;try {aClass = className.getClass();Field[] declaredFields = aClass.getDeclaredFields();for (Field field:declaredFields) {field.setAccessible(true);String names = fieldName.substring(0, 1).toUpperCase() + fieldName.substring(1, fieldName.length());if(field.getName().equals(fieldName) && field.getType().getName().equals("java.math.BigDecimal")){aClass.getMethod("set"+names,BigDecimal.class).invoke(className,new BigDecimal(""+cell));}else if(field.getName().equals(fieldName) && field.getType().getName().equals("java.lang.String")){aClass.getMethod("set"+names,String.class).invoke(className,cell.getStringCellValue().toString());}else if(field.getName().equals(fieldName) && field.getType().getName().equals("java.lang.Integer")){aClass.getMethod("set"+names,Integer.class).invoke(className,cell);}else if(field.getName().equals(fieldName) && field.getType().getName().equals("java.lang.Double")){aClass.getMethod("set"+names,Double.class).invoke(className,cell);}}} catch (IllegalAccessException e) {e.printStackTrace();} catch (NoSuchMethodException e) {e.printStackTrace();} catch (InvocationTargetException e) {e.printStackTrace();}return className; }/*** 本段代碼解析xls文件* @param*/ public List<T> analysisXls(InputStream in,Class<?> clazz,String[] fieldsName,String[] fieldsIsNull) {int totalrows = 0;int totalCell = 0;List<T> list = new ArrayList();logger.info("==================== 開始解析xls文件 =========================");//流讀取文件//創(chuàng)建文件HSSFWorkbook wb = null;try {wb = new HSSFWorkbook(in);//讀取頁(yè)數(shù)for(int num = 0 ; num < wb.getNumberOfSheets() ; num ++){Sheet xs = wb.getSheetAt(num);if(xs == null){continue;}totalrows = xs.getLastRowNum()+1;for (int rnum = 1 ; rnum < totalrows ; rnum ++){boolean flag = false;T o = null;try {o = (T)clazz.newInstance();} catch (InstantiationException e) {e.printStackTrace();} catch (IllegalAccessException e) {e.printStackTrace();}Row row = xs.getRow(rnum);if(row != null){totalCell = row.getLastCellNum();int nullCellNumb = 0;for (int cnum = 0 ; cnum < totalCell ; cnum ++){Cell cell = row.getCell(cnum);if(null == cell){nullCellNumb++;if(nullCellNumb>=10){break;}continue;}if( cell != null && !"".equals(cell.toString().trim())){this.reflectDeal(o, cell, fieldsName[cnum]);}else {for (int x=0;x<fieldsIsNull.length;x++){if(fieldsIsNull[x].equals(fieldsName[cnum])){flag = true;break;}}}}if (flag){continue;}list.add(o);}else {return list;}}}} catch (IOException e) {e.printStackTrace();}finally {try {in.close();if(null != wb){wb.close();}} catch (IOException e) {e.printStackTrace();}}return list; }

/**

* 本段代碼解析xlsx文件* @param* @param clazz* @param fieldsName* @return*/ public List<T> analysisXlsx(InputStream in,Class<?> clazz,String[] fieldsName,String[] fieldsIsNull){int totalrows = 0;int totalCell = 0;List<T> list = new ArrayList();logger.info("==================== 開始解析xlsx文件 =========================");//流讀取文件//創(chuàng)建文件XSSFWorkbook wb = null;try {wb = new XSSFWorkbook(OPCPackage.open(in));//讀取頁(yè)數(shù)for(int num = 0 ; num < wb.getNumberOfSheets() ; num ++){Sheet xs = wb.getSheetAt(num);if(xs == null){continue;}totalrows = xs.getLastRowNum()+1;for (int rnum = 1 ; rnum < totalrows ; rnum ++){boolean flag = false;T o = (T)clazz.newInstance();Row row = xs.getRow(rnum);if(row != null){totalCell = row.getLastCellNum();int nullCellNumb = 0;for (int cnum = 0 ; cnum < totalCell ; cnum ++){Cell cell = row.getCell(cnum);if(null == cell){nullCellNumb++;if(nullCellNumb>=10){break;}continue;}if( cell != null && !"".equals(cell.toString().trim())){nullCellNumb = 0;this.reflectDeal(o, cell, fieldsName[cnum]);}else {for (int x=0;x<fieldsIsNull.length;x++){if(fieldsIsNull[x].equals(fieldsName[cnum])){flag = true;break;}}}}if (flag){continue;}list.add(o);}else {return list;}}}} catch (IOException e) {e.printStackTrace();} catch (IllegalAccessException e) {e.printStackTrace();} catch (InstantiationException e) {e.printStackTrace();} catch (InvalidFormatException e) {logger.info("======= XSSF創(chuàng)建文件失敗 ====");e.printStackTrace();}finally {try {in.close();if(null != wb){wb.close();}} catch (IOException e) {e.printStackTrace();}}return list; }

/**

*此段代碼區(qū)分e'xcel版本，分別調(diào)用哪個(gè)方法* @param* @param clazz* @param fieldsName* @return* @throws IOException*/ public List<T> readxlsAndXlsx(InputStream in,Class<?> clazz,String[] fieldsName,String fileName,String[] fieldsIsNull) {if(null != in ){String postfix = ExcelImport.getpostfix(fileName);if(OFFICE_EXCEL_2003_POSTFIX.equals(postfix)){return this.analysisXls(in,clazz,fieldsName,fieldsIsNull);}else if(OFFICE_EXCEL_2007_POSTFIX.equals(postfix)){return this.analysisXlsx(in,clazz,fieldsName,fieldsIsNull);}else {return null;}}return null; }

/**

* 獲取文件后綴名* @param path* @return*/ public static String getpostfix(String path){if(path == null || EMPTY.equals(path.trim())){return "";}if(path.contains(POINT)){return path.substring(path.lastIndexOf(POINT)+1,path.length());}return ""; }

總結(jié)

以上是生活随笔為你收集整理的java excel上传--poi的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。