Apache POIとの比較

@Data
@AllArgsConstructor
public class InvoiceData {
    private ContactInfo customer;
    private ContactInfo shop;
    private List<OrderLine> orderLineList;
    private LocalDate issueDate;
}
 
@Data
@AllArgsConstructor
public class ContactInfo {
    private String name;
    private String address;
    private String zip;
    private String phone;
}
 
 
@Data
@AllArgsConstructor
public class OrderLine {
    private String productName;
    private int productPrice;
    private int count;
}
 
// 使用するデータ
InvoiceData invoice = new InvoiceData(
        new ContactInfo(
                "田中 太郎",
                "東京都港区X-Y-Z 1-2-3",
                "123-46587",
                "091-2568-4514"
        ),
        new ContactInfo(
                "CYBER SHOP ABC",
                "山形県酒田市A-B-C 1-2-3",
                "598-123654",
                "098-15468-41114"
        ),
        orderLines,
        LocalDate.of(2018, 11, 20)
 );

{
    "customer": {
        "name": "田中 太郎",
        "address": "東京都港区X-Y-Z 1-2-3",
        "zip": "123-46587",
        "phone": "091-2568-4514"
    },
    "shop": {
        "name": "CYBER SHOP ABC",
        "address": "山形県酒田市A-B-C 1-2-3",
        "zip": "598-123654",
        "phone": "098-15468-41114"
    },
    "orderLineList": [
        {
            "productName": "128GB Micro SDカード",
            "productPrice": 3800,
            "count": 2
        },
        {
            "productName": "5インチ ガラス液晶フィルム",
            "productPrice": 1200,
            "count": 1
        },
        {
            "productName": "ノンフロン ダストブロワー 2パック",
            "productPrice": 800,
            "count": 1
        }
    ],
    "issueDate": "2018-11-20"
}

Workbook wb = WorkbookFactory.create(PoiInvoiceRenderer.class.getResourceAsStream("/nouhinsho-poi.xlsx"));
Sheet sheet = wb.getSheetAt(0);
 
// 顧客
cellAt(sheet, 4, 2).setCellValue(data.getCustomer().getName() + " 様");
cellAt(sheet, 5, 2).setCellValue("〒" + data.getCustomer().getZip());
cellAt(sheet, 6, 2).setCellValue(data.getCustomer().getAddress());
cellAt(sheet, 7, 2).setCellValue("TEL: " + data.getCustomer().getPhone());
 
// 発行日
cellAt(sheet, 4, 8).setCellValue(Date.from(data.getIssueDate().atStartOfDay(ZoneId.systemDefault()).toInstant()));
 
// ショップ
cellAt(sheet, 6, 11).setCellValue(data.getShop().getName());
cellAt(sheet, 7, 11).setCellValue("〒" + data.getShop().getZip());
cellAt(sheet, 8, 11).setCellValue(data.getShop().getAddress());
cellAt(sheet, 9, 11).setCellValue("TEL: " + data.getShop().getPhone());

// 明細
int rowIdx = 12;
CellStyle currencyStyle = wb.createCellStyle();
DataFormat format = wb.createDataFormat();
currencyStyle.setDataFormat(format.getFormat("¥#,###"));
 
for(OrderLine line : data.getOrderLineList()) {
    // sheet.shiftRows(rowIdx, sheet.getLastRowNum(), 8, true, true); // bug?
    sheet.createRow(rowIdx);
 
    Row row = sheet.getRow(rowIdx);
    row.createCell(2, CellType.STRING).setCellValue(line.getProductName());
    row.createCell(8, CellType.NUMERIC).setCellValue(line.getProductPrice());
    row.createCell(9, CellType.NUMERIC).setCellValue(line.getCount());
    row.createCell(10, CellType.FORMULA).setCellFormula("I" + (rowIdx + 1) + "*J" + (rowIdx + 1));
 
    // style
    cellAt(sheet, rowIdx, 8).setCellStyle(currencyStyle);
    cellAt(sheet, rowIdx, 10).setCellStyle(currencyStyle);
    sheet.addMergedRegion(new CellRangeAddress(rowIdx, rowIdx, 10, 11));
    rowIdx++;
}

// 合計
sheet.createRow(rowIdx++);
Row row = sheet.createRow(rowIdx);
row.createCell(9, CellType.STRING).setCellValue("合計");
row.createCell(10, CellType.FORMULA).setCellFormula("SUM(K13:K" + (13 + data.getOrderLineList().size() - 1) + ")");
sheet.addMergedRegion(new CellRangeAddress(rowIdx, rowIdx, 10, 11));
 
CellStyle currencyAndBorder = wb.createCellStyle();
currencyAndBorder.setBorderBottom(BorderStyle.MEDIUM);
currencyAndBorder.setDataFormat(format.getFormat("¥#,###"));
cellAt(sheet, rowIdx, 9).setCellStyle(currencyAndBorder);
cellAt(sheet, rowIdx, 10).setCellStyle(currencyAndBorder);
 
row.createCell(11, CellType.STRING);
cellAt(sheet, rowIdx, 11).setCellStyle(currencyAndBorder);