ArrayList<String> list1 = new ArrayList<String>() ;
List<stu> list = new ArrayList<stu>();
stu s = new stu();
Workbook rwb;
try {
rwb = Workbook.getWorkbook(new File("D://aa.xls"));
Sheet rs=rwb.getSheet(0);//或者rwb.getSheet(0)
int clos=rs.getColumns();//得到所有的列
int rows=rs.getRows();//得到所有的行
System.out.println("clos:"+clos+" rows:"+rows);
for (int i = 0; i < rows; i++) {
for (int j = 0; j < clos; j++) {
//第一个是列数,第二个是行数
String id=rs.getCell(j++, i).getContents();//默认最左边编号也算一列 所以这里得j++
String name=rs.getCell(j++, i).getContents();
String sex=rs.getCell(j++, i).getContents();
String num=rs.getCell(j++, i).getContents();
new stu(Integer.parseInt(id), name, sex, num);
s.setName(name);
s.setAge(num);
s.setSex(sex);
adminServiceImpl.test(s);
list1.add(id);
list1.add(name);
list1.add(sex);
list1.add(num);
}
}
//test
for(stu ss: list){
System.out.println(ss);
}
//test
for (int i = 0; i < list1.size(); i++) {
System.out.println(list1.get(i));
}