Axyra Sheets for Java

// Generated by the Axyra Agent Skill
// Task: fill invoice-template.xlsx with the order's data and export it as a PDF.
// Template layout (Sheet1): B2 = customer, B3 = invoice date, line items from A6.
// Axyra does not recalculate on open, so totals are recalculated before rendering.
try (Workbook wb = Workbook.open(Path.of("invoice-template.xlsx"))) {
    Sheet sheet = wb.sheet("Sheet1");
    sheet.cell(1, 1).setValue(CellValue.text(order.getCustomerName())); // B2
    sheet.cell(2, 1).setDate(order.getInvoiceDate());                   // B3
    sheet.importData(5, 0, order.getLineItems(),                        // from A6
            ImportOptions.builder().headers(false).build());
    wb.recalculate();
    wb.renderPdf(Path.of("output/invoice-" + order.getId() + ".pdf"));
}