书接上文
poi实现Excel导入
@Override
public List<Student> importExcelStudent(String xlsPath) throws IOException {
List<Student> students = new ArrayList<>();
//获得一个绝对路径的流
FileInputStream fileInputStream = new FileInputStream(xlsPath);
//新建一个excel工作薄
Workbook wb = new HSSFWorkbook(fileInputStream);
//得到excel工作薄的第一个表单
Sheet sheet = wb.getSheetAt(0);
//迭代表单(遍历每一行)
for (Row row : sheet) {
if (row.getRowNum() == 0) {
continue;
}
Student student = new Student();
student.setName(row.getCell(0).getStringCellValue());
student.setId(row.getCell(1).getStringCellValue());
student.setAge((int)row.getCell(2).getNumericCellValue());
student.setSex(row.getCell(3).getStringCellValue());
students.add(student);
}
fileInputStream.close();
return students;
}