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