// 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;
}
