<dependency>
<groupId>com.ebay.xcelite</groupId>
<artifactId>xcelite</artifactId>
<version>4.6.0</version>
</dependency>
public class Employee {
private String name;
private int age;
private String position;
// Getter and setter methods
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getPosition() {
return position;
}
public void setPosition(String position) {
this.position = position;
}
}
Xcelite xcelite = new Xcelite(new File("employees.xlsx"));
XceliteSheet sheet = xcelite.getSheet("Sheet1");
List<Employee> employees = sheet.getObjects(Employee.class);
for (Employee employee : employees) {
System.out.println(employee.getName());
}
SheetWriter<Employee> sheetWriter = xcelite.createSheet("Sheet1", Employee.class);
Employee modifiedEmployee = new Employee();
sheetWriter.append(modifiedEmployee);
sheetWriter.write();
