<dependencies>
<dependency>
<groupId>com.ebay</groupId>
<artifactId>xcelite</artifactId>
<version>1.3</version>
</dependency>
</dependencies>
File excelFile = new File("path/to/excel/file.xlsx");
Xcelite xcelite = new Xcelite(excelFile);
Sheet sheet = xcelite.getSheet(0);
List<Row> rows = sheet.getRows();
for (Row row : rows) {
List<Cell> cells = row.getCells();
for (Cell cell : cells) {
Object value = cell.getValue();
}
}
File excelFile = new File("path/to/new/excel/file.xlsx");
Xcelite xcelite = new Xcelite();
Sheet sheet = xcelite.createSheet("Sheet1");
List<List<Object>> data = new ArrayList<>();
List<Object> rowData = new ArrayList<>();
rowData.add(25);
data.add(rowData);
rowData = new ArrayList<>();
rowData.add(30);
data.add(rowData);
for (List<Object> row : data) {
sheet.addRow(row);
}
try (FileOutputStream outputStream = new FileOutputStream(excelFile)) {
xcelite.write(outputStream);
} catch (IOException e) {
e.printStackTrace();
}
