// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getActiveSheet(); worksheet.getRange("A1").setValue("Sales by Country"); worksheet.getRange("A2:F5").setValue(new Object[][] { {"Countries", 2016, 2017, 2018, 2019, 2020}, {"China", 243000, 291000, 465000, 282000, 213000}, {"India", 448000, 358000, 332000, 489000, 302000}, {"UnitedStates", 439000, 276000, 413000, 396000, 392000} }); worksheet.getRange("G2").setValue("SparkLine"); worksheet.getRange("G3:G5").setFormula("=LINESPARKLINE(B3:F3,1,,,\"{showMarkers:TRUE,lineWeight:1.5,markersColor:#7030a0}\")"); 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("B3:F5").setNumberFormat("$#,##0"); worksheet.getRange("A1:G2").getFont().setBold(true); worksheet.getRange("A1").getFont().setSize(15); worksheet.getRange("A2:G5").getFont().setSize(13); worksheet.getRange("A:F").autoFit(); worksheet.getRange("1:5").setRowHeight(25); worksheet.getRange("G1").setColumnWidth(30); worksheet.getPageSetup().setOrientation(PageOrientation.Landscape); // Save to a pdf file workbook.save("LineSparkline.pdf");