// read the data from the excel public List readFromXML(InputStream input) throws Exception { List<TeamRecord> teamRecord = new ArrayList<TeamRecord>(); List<String> wrong_data = new ArrayList<String>(); List rt_list = new ArrayList<List>(); HashSet<String> wrong_users = new HashSet<String>(); // String log="Start read Excel"; // System.out.println(log); // all_log.add(log); try { POIFSFileSystem fs = new POIFSFileSystem(input); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheetAt(0); boolean vali_date = true; boolean firstLine = true; setRmLoginNames(trackingTicketScriptDao.findrmLoginNames()); for (Iterator<Row> rit = sheet.rowIterator(); rit.hasNext(); ) { Row row = rit.next(); if (firstLine) { firstLine = false; } else { vali_date = validation.validate_exceldata(row, wrong_users, wrong_data); if (vali_date == true) { teamRecord.add(readexcelline(row)); } } rt_list.add(teamRecord); rt_list.add(wrong_data); rt_list.add(wrong_users); } } catch (IOException ex) { wrong_data.add("Excel is NULL,Please check Excel!"); rt_list.add(teamRecord); rt_list.add(wrong_data); rt_list.add(wrong_users); return rt_list; } return rt_list; }