Java excel library (Apache POI inside)

<dependency>    <groupId>hr.com.vgv</groupId>    <artifactId>excel-io</artifactId></dependency>

Create spreadsheet

newXsWorkbook(newXsSheet(newXsRow()            .with(newTextCells("name","email","salary","bonus","total"))            .with(newXsStyle(newForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()),newFillPattern(FillPatternType.SOLID_FOREGROUND)                )            ),newXsRow()            .with(newTextCells("Steve Hook","steve.hook@gmail.com"))            .with(newNumberCells(160000.0,35337.6))            .with(newFormulaCell("SUM(C3:D3)")                .with(newXsStyle(newForegroundColor(IndexedColors.RED.getIndex()),newFillPattern(FillPatternType.SOLID_FOREGROUND)                    )                )            )            .with(newXsProps<>(newHeight((short)500)))    )).saveTo("Test.xlsx");

Read and modify spreadsheet

newXsWorkbook("Test.xlsx")    .with(newXsSheet.ReadFrom(0)        .with(newXsRow(2,newTextCell(1,"UPDATED")            )        )    ).saveTo("Updated.xlsx");

Custom styles

newXsWorkbook(newXsSheet(newMyCustomRow("Boris","Miksic","ID:2450"),newMyCustomRow("Mirko","Mirkic","ID:1690")    )).saveTo("Test.xlsx");

privatestaticclassMyCustomRowextendsRowTemplate {publicMyCustomRow(finalStringname,finalStringsurname,finalStringid) {super(newXsRow()                .with(newTextCells(name,surname))                .with(newMyGreyCell(newTextCell(id)))        );    }}privatestaticclassMyGreyCellextendsCellTemplate {publicMyGreyCell(finalECellcell) {super(cell.with(newXsStyle(newForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()),newFillPattern(FillPatternType.SOLID_FOREGROUND)            )        ));    }}

Contribution

mvn clean install -Pqulice