<dependency>
<groupId>com.googlecode.xcelite</groupId>
<artifactId>xcelite</artifactId>
<version>2.5.0</version>
</dependency>
groovy
compile 'com.googlecode.xcelite:xcelite:2.5.0'
public class Student {
private String name;
private int age;
private double score;
// ...
}
import com.googlecode.xcelite.reader.SheetReader;
import com.googlecode.xcelite.sheet.Sheet;
import java.io.File;
import java.util.List;
public class ExcelDataValidatorConverter {
public static void main(String[] args) {
try {
File file = new File("path/to/excel/file.xlsx");
SheetReader<Student> sheetReader = new SheetReader<Student>(file);
Sheet sheet = sheetReader.getSheet(0);
List<Student> students = sheetReader.read(Student.class);
for (Student student : students) {
System.out.println("------------------------------");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
