// Create a new workbook Workbook workbook = new Workbook(); Object[][] data = new Object[][] { {"Customer", "0-30 Days", "30-60 Days", "60-90 Days", ">90 Days"}, {"Customer A", 1200.15, 1916.18, 1105.23, 1806.53}, {"Customer B", 896.23, 1005.53, 1800.56, 1150.49}, {"Customer C", 827.63, 1009.23, 1869.23, 1002.56} }; IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("B2:E5").setValue(data); worksheet.getRange("B:F").setColumnWidth(15); worksheet.getRange("B:E").setHorizontalAlignment(HorizontalAlignment.Center); ITable table = worksheet.getTables().add(worksheet.getRange("B2:F5"), true); table.setTableStyle(workbook.getTableStyles().get("TableStyleMedium3")); table.getColumns().get(4).setName("Sparklines"); //create a new group of sparklines. worksheet.getRange("F3").getSparklineGroups().add(SparkType.Line, "C3:E3"); worksheet.getRange("F4").getSparklineGroups().add(SparkType.Column, "C4:E4"); worksheet.getRange("F5").getSparklineGroups().add(SparkType.ColumnStacked100, "C5:E5"); // Save to a pdf file workbook.save("SaveSparklinesToPDF.pdf");
// Create a new workbook var workbook = Workbook() val data = arrayOf(arrayOf("Customer", "0-30 Days", "30-60 Days", "60-90 Days", ">90 Days"), arrayOf("Customer A", 1200.15, 1916.18, 1105.23, 1806.53), arrayOf("Customer B", 896.23, 1005.53, 1800.56, 1150.49), arrayOf("Customer C", 827.63, 1009.23, 1869.23, 1002.56)) val worksheet = workbook.worksheets.get(0) worksheet.getRange("B2:E5").value = data worksheet.getRange("B:F").columnWidth = 15.0 worksheet.getRange("B:E").horizontalAlignment = HorizontalAlignment.Center val table = worksheet.tables.add(worksheet.getRange("B2:F5"), true) table.tableStyle = workbook.tableStyles.get("TableStyleMedium3") table.columns.get(4).name = "Sparklines" //create a new group of sparklines. worksheet.getRange("F3").sparklineGroups.add(SparkType.Line, "C3:E3") worksheet.getRange("F4").sparklineGroups.add(SparkType.Column, "C4:E4") worksheet.getRange("F5").sparklineGroups.add(SparkType.ColumnStacked100, "C5:E5") // Save to a pdf file workbook.save("SaveSparklinesToPDF.pdf")