[Java] Java POI实现将导入Excel文件的示例代码

<dependency>
  <groupid>org.apache.poi</groupid>
  <artifactid>poi</artifactid>
  <version>release</version>
</dependency>
<dependency>
  <groupid>org.apache.poi</groupid>
  <artifactid>poi-ooxml</artifactid>
  <version>release</version>
</dependency>

workbook workbook = null;
try {
  if (file.getpath().endswith("xls")) {
  system.out.println("这是2003版本");
  workbook = new xssfworkbook(new fileinputstream(file));
  } else if (file.getpath().endswith("xlsx")){
  workbook = new hssfworkbook(new fileinputstream(file));
  system.out.println("这是2007版本");
  }
    
} catch (ioexception e) {
  e.printstacktrace();
}

// 获取第一个张表
sheet sheet = workbook.getsheetat(0);
   
// 获取每行中的字段
for (int i = 0; i <= sheet.getlastrownum(); i++) {
  row row = sheet.getrow(i);  // 获取行
 
  // 获取单元格中的值
  string studentnum = row.getcell(0).getstringcellvalue();  
  string name = row.getcell(1).getstringcellvalue();
  string phone = row.getcell(2).getstringcellvalue();
}

list<student> studentlist = new arraylist<>();
 
for (int i = 0; i <= sheet.getlastrownum(); i++) {
  row row = sheet.getrow(i);  // 获取行
 
  // 获取单元格中的值
  string studentnum = row.getcell(0).getstringcellvalue();  
  string name = row.getcell(1).getstringcellvalue();
  string phone = row.getcell(2).getstringcellvalue();
  
  student student = new student();
  student.setstudentnumber(studentnum);
  student.setname(name);
  student.setphonenumber(phone);
  
  studentlist.add(student);
}
 
// 持久化
studentrepository.saveall(studentlist);