Package net.objectlab.kit.util.excel

This package provides a series of fluent classes that enable EASY creation of Excel Spreadsheets.

See: Description

Class Summary

Class	Description
Excel
ExcelCell
ExcelRow
ExcelSheet
ExcelStyle
ExcelStyle.Builder
ExcelWorkbook	Wrapper for the POI Workbook, allowing creation of simple spreadsheet in a fluent manner.

Exception Summary

Exception	Description
ExcelException

Package net.objectlab.kit.util.excel Description

This package provides a series of fluent classes that enable EASY creation of Excel Spreadsheets.

       ExcelWorkbook.newBook().newSheet("Countries").newRow() // HEADER
                .newCell("Country").header().newCell("Population 2018").header().newCell("Percentage").header() //
                .newRow() // FIRST ROW
                .newCell("Belgium").newCell(11_000_000L).numericFormat()//
                .newCell(BigDecimal.valueOf(11_000_000d / 72_000_000d)).percentFormat() //

                .newRow() // SECOND ROW
                .newCell("UK").newCell(62_000_000L).numericFormat() //
                .newCell(BigDecimal.valueOf(62_000_000d / 72_000_000d)).percentFormat() //

                .newRow() // TOTAL
                .newCell("Total").bold().newCell(72_000_000L).numericFormat().bold() //
                .autoSizeColumn(0, 1) //
                .save("test.xlsx"); // Save it