java poi匯入EXCEL

標籤：

import jxl.DateCell;import jxl.NumberCell;import org.apache.log4j.Logger;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFDateUtil;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;public String txtTableImport(String tableName, String path,   HttpServletRequest request) {   File dataFile = new File(path);   try {    // 匯入excel檔案    FileInputStream is=new  FileInputStream(dataFile);    HSSFWorkbook wbs =  new HSSFWorkbook(is);    HSSFSheet   childSheet =  wbs.getSheetAt(0);        int x = childSheet.getLastRowNum();   // 有 X 行     for(int j=1; j<=x;j++ ){      HSSFRow  row = childSheet.getRow(j);      int y =  row.getLastCellNum() ;  //  有Y列      String name=  GlobalFunc.toString(row.getCell(0)); //讀取列的值      String age  GlobalFunc.toString(row.getCell(1)); //讀取列的值           }   } catch (Exception e) {    e.printStackTrace();    return Constants.uploadFail; //匯入失敗：未知錯誤！   }     logger.debug("data import successfully!");       return Constants.uploadSuccess;//匯入成功！  }

java poi匯入EXCEL