java 从EXCEL导入到数据库

不念不忘少年蓝@ 2022-09-13 06:21 405阅读 0赞 
  1. package com.fh.util;
  3. import java.io.File;
  4. import java.io.FileInputStream;
  5. import java.util.ArrayList;
  6. import java.util.List;
  8. import org.apache.poi.hssf.usermodel.HSSFCell;
  9. import org.apache.poi.hssf.usermodel.HSSFRow;
  10. import org.apache.poi.hssf.usermodel.HSSFSheet;
  11. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  13. /**
  14.  * 说明：从EXCEL导入到数据库
  15.  * 作者：FH Admin
  16.  * from：fhadmin.cn
  17.  */
  18. public class ObjectExcelRead {
  20.     /**
  21.      * @param filepath //文件路径
  22.      * @param filename //文件名
  23.      * @param startrow //开始行号
  24.      * @param startcol //开始列号
  25.      * @param sheetnum //sheet
  26.      * @return list
  27.      */
  28.     public static List<Object> readExcel(String filepath, String filename, int startrow, int startcol, int sheetnum) {
  29.         List<Object> varList = new ArrayList<Object>();
  31.         try {
  32.             File target = new File(filepath, filename);
  33.             FileInputStream fi = new FileInputStream(target);
  34.             HSSFWorkbook wb = new HSSFWorkbook(fi);
  35.             HSSFSheet sheet = wb.getSheetAt(sheetnum);                     //sheet 从0开始
  36.             int rowNum = sheet.getLastRowNum() + 1;                     //取得最后一行的行号
  38.             for (int i = startrow; i < rowNum; i++) {                    //行循环开始
  40.                 PageData varpd = new PageData();
  41.                 HSSFRow row = sheet.getRow(i);                             //行
  42.                 int cellNum = row.getLastCellNum();                     //每行的最后一个单元格位置
  44.                 for (int j = startcol; j < cellNum; j++) {                //列循环开始
  46.                     HSSFCell cell = row.getCell(Short.parseShort(j + ""));
  47.                     String cellValue = null;
  48.                     if (null != cell) {
  49.                         switch (cell.getCellType()) {                     // 判断excel单元格内容的格式，并对其进行转换，以便插入数据库
  50.                         case 0:
  51.                             cellValue = String.valueOf((int) cell.getNumericCellValue());
  52.                             break;
  53.                         case 1:
  54.                             cellValue = cell.getStringCellValue();
  55.                             break;
  56.                         case 2:
  57.                             cellValue = cell.getNumericCellValue() + "";
  58.                             // cellValue = String.valueOf(cell.getDateCellValue());
  59.                             break;
  60.                         case 3:
  61.                             cellValue = "";
  62.                             break;
  63.                         case 4:
  64.                             cellValue = String.valueOf(cell.getBooleanCellValue());
  65.                             break;
  66.                         case 5:
  67.                             cellValue = String.valueOf(cell.getErrorCellValue());
  68.                             break;
  69.                         }
  70.                     } else {
  71.                         cellValue = "";
  72.                     }
  74.                     varpd.put("var"+j, cellValue);
  76.                 }
  77.                 varList.add(varpd);
  78.             }
  80.         } catch (Exception e) {
  81.             System.out.println(e);
  82.         }
  84.         return varList;
  85.     }
  86. }

发表评论

表情：
评论列表 （有 0 条评论，405人围观）

还没有评论，来说两句吧...

相关阅读