// 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");