import com.tchepannou.kiosk.core.ejb.repository.xcelite.Xcelite;
import com.tchepannou.kiosk.core.ejb.repository.xcelite.XceliteOptions;
import com.tchepannou.kiosk.core.ejb.repository.xcelite.reader.*;
import com.tchepannou.kiosk.core.ejb.repository.xcelite.sheet.RowMapper;
import com.tchepannou.kiosk.core.ejb.repository.xcelite.sheet.Sheet;
import java.io.File;
import java.io.IOException;
Xcelite xcelite = new Xcelite();
XceliteOptions options = new XceliteOptions();
try {
File file = new File("path-to-your-excel-file");
XceliteReader reader = xcelite.createReader(file);
RowMapper<YourDataObject> mapper = new RowMapper<YourDataObject>() {
@Override
public YourDataObject mapRow(RowReader reader) {
return new YourDataObject();
}
};
List<YourDataObject> data = sheet.mapTo(mapper);
for (YourDataObject obj : data) {
}
} catch (IOException e) {
e.printStackTrace();
}
