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();    }}

?