net.objectlab.kit.util.excel

Class ExcelWorkbook

java.lang.Object

net.objectlab.kit.util.excel.ExcelWorkbook

public class ExcelWorkbook
extends Object

Wrapper for the POI Workbook, allowing creation of simple spreadsheet in a fluent manner. The default format is opinionated.

       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
 

Author:

Benoit Xhenseval

Constructor Summary

Constructors

Constructor and Description
ExcelWorkbook(boolean streaming)

Method Summary

Modifier and Type	Method and Description
org.apache.poi.ss.usermodel.CellStyle	cloneStyle(int styleHashCode)
org.apache.poi.ss.usermodel.Font	createFont()
ExcelWorkbook	dispose()
Optional<org.apache.poi.ss.usermodel.CellStyle>	findStyle(int styleHashCode)
static ExcelWorkbook	newInMemoryWorkbook()
ExcelSheet	newSheet(String name)
static ExcelWorkbook	newStreamingWorkbook()
org.apache.poi.ss.usermodel.Workbook	poiWorkbook()
ExcelWorkbook	save(String fileName)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExcelWorkbook

public ExcelWorkbook(boolean streaming)

Method Detail

newStreamingWorkbook

public static ExcelWorkbook newStreamingWorkbook()

newInMemoryWorkbook

public static ExcelWorkbook newInMemoryWorkbook()

newSheet

public ExcelSheet newSheet(String name)

poiWorkbook

public org.apache.poi.ss.usermodel.Workbook poiWorkbook()

dispose

public ExcelWorkbook dispose()

save

public ExcelWorkbook save(String fileName)
                   throws IOException

Throws:

IOException

createFont

public org.apache.poi.ss.usermodel.Font createFont()

findStyle

public Optional<org.apache.poi.ss.usermodel.CellStyle> findStyle(int styleHashCode)

cloneStyle

public org.apache.poi.ss.usermodel.CellStyle cloneStyle(int styleHashCode)