java 读取 Excel 文件

	/**李树超
	 * import form by Excel
	 */
	@Transactional 
	public void readByExcel(File upload){
	    try {
	        FileInputStream file = new FileInputStream(upload);	
	        //Create Workbook instance holding reference to .xlsx file
	        XSSFWorkbook workbook = new XSSFWorkbook(file);
	        //Get first/desired sheet from the workbook
	        XSSFSheet sheet = workbook.getSheetAt(0);
	        //Iterate through each rows one by one
	        Iterator<Row> rowIterator = sheet.iterator();
	        while (rowIterator.hasNext()){
	            Row row = rowIterator.next();
	            List<String> list = new ArrayList<String>();
	            //For each row, iterate through all the columns
	            Iterator<Cell> cellIterator = row.cellIterator(); 
	            while (cellIterator.hasNext()){
	                Cell cell = cellIterator.next();
	                if (cell.getColumnIndex() > 19){
	                	break;
	                }
	                String cellValue = "";
	                //Check the cell type and format accordingly
	                switch (cell.getCellType()){
	                    case Cell.CELL_TYPE_NUMERIC:
	                    	cellValue = String.valueOf(cell.getNumericCellValue());
	                        break;
	                    case Cell.CELL_TYPE_STRING:
	                    	cellValue = cell.getStringCellValue();
	                        break;
	                }
	                list.add(cellValue); 
	            }
	            list.add("11111_NO");
	            list.add("");
	            list.add("");
	            list.add("");
	            list.add("");
	            //materialStockedDAO.insertBySql(list);
	            System.out.println("");
	        }
	        file.close();
	    }
	    catch (Exception e){
	        e.printStackTrace();
	    }
	}