// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getActiveSheet(); worksheet.getRange("A1").setValue("Employee Performance"); worksheet.getRange("A2:F5").setValue(new Object[][] { {"Team Member", "Wk1", "Wk2", "Wk3", "Wk4", "Wk5"}, {"Pamela Nelson", 5, 1, 7, 5, 8}, {"Gabriel Reed", 1, 2, 4, 2, 9}, {"Christina Robbins", 4, 10, 8, 5, 10} }); worksheet.getRange("H2").setValue("Target (tasks per week):"); worksheet.getRange("I2").setValue(5); worksheet.getRange("G2").setValue("SparkLine"); // Since the formula contains a dynamic array formula (B3:F3-$I$2), Formula2 needs to be used. worksheet.getRange("G3:G5").setFormula2("=WINLOSSSPARKLINE(B3:F3-$I$2,1,,,\"{showNegative:TRUE}\")"); worksheet.getRange("A1:G1").merge(); worksheet.getRange("A1").getInterior().setColor(Color.GetPurple()); worksheet.getRange("A1").getFont().setColor(Color.GetWhite()); worksheet.getRange("A1").setHorizontalAlignment(HorizontalAlignment.Center); worksheet.getRange("A1:G5").getBorders().setLineStyle(BorderLineStyle.Thin); worksheet.getRange("A1:G2").getFont().setBold(true); worksheet.getRange("A1").getFont().setSize(15); worksheet.getRange("A2:G5").getFont().setSize(13); worksheet.getRange("H2:I2").getFont().setBold(true); worksheet.getRange("H2:I2").getFont().setSize(13); worksheet.getRange("A:F").autoFit(); worksheet.getRange("1:5").setRowHeight(25); worksheet.getRange("G1:H1").setColumnWidth(30); worksheet.getPageSetup().setOrientation(PageOrientation.Landscape); // Save to a pdf file workbook.save("WinLossSparkline.pdf");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.activeSheet worksheet.getRange("A1").value = "Employee Performance" worksheet.getRange("A2:F5").value = arrayOf( arrayOf("Team Member", "Wk1", "Wk2", "Wk3", "Wk4", "Wk5"), arrayOf("Pamela Nelson", 5, 1, 7, 5, 8), arrayOf("Gabriel Reed", 1, 2, 4, 2, 9), arrayOf("Christina Robbins", 4, 10, 8, 5, 10) ) worksheet.getRange("H2").value = "Target (tasks per week):" worksheet.getRange("I2").value = 5 worksheet.getRange("G2").value = "SparkLine" // Since the formula contains a dynamic array formula (B3:F3-$I$2), Formula2 needs to be used. worksheet.getRange("G3:G5").formula2 = "=WINLOSSSPARKLINE(B3:F3-\$I$2,1,,,\"{showNegative:TRUE}\")" worksheet.getRange("A1:G1").merge() worksheet.getRange("A1").interior.color = Color.GetPurple() worksheet.getRange("A1").font.color = Color.GetWhite() worksheet.getRange("A1").horizontalAlignment = HorizontalAlignment.Center worksheet.getRange("A1:G5").borders.lineStyle = BorderLineStyle.Thin worksheet.getRange("A1:G2").font.bold = true worksheet.getRange("A1").font.size = 15.0 worksheet.getRange("A2:G5").font.size = 13.0 worksheet.getRange("H2:I2").font.bold = true worksheet.getRange("H2:I2").font.size = 13.0 worksheet.getRange("A:F").autoFit() worksheet.getRange("1:5").rowHeight = 25.0 worksheet.getRange("G1:H1").columnWidth = 30.0 worksheet.pageSetup.orientation = PageOrientation.Landscape // Save to a pdf file workbook.save("WinLossSparkline.pdf")