Excel API Library for Java - Sample Browser | Document Solutions | Line sparkline
[
フレーム]
src="bundle.js">
Refer to the following example code to learn how to add a line sparkline formula in Document Solutions for Excel. A line sparkline utilizes line charts to represent data, emphasizing the changes and fluctuations in the data.
// 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");
// Create a new workbook
var workbook = Workbook()
val worksheet = workbook.activeSheet
worksheet.getRange("A1").value = "Sales by Country"
worksheet.getRange("A2:F5").value = arrayOf(
arrayOf
("Countries", 2016, 2017, 2018, 2019, 2020),
arrayOf("China", 243000, 291000, 465000, 282000, 213000),
arrayOf("India", 448000, 358000, 332000, 489000, 302000),
arrayOf("UnitedStates", 439000, 276000, 413000, 396000, 392000)
)
worksheet.getRange("G2").value = "SparkLine"
worksheet.getRange("G3:G5").formula =
"=LINESPARKLINE(B3:F3,1,,,\"{showMarkers:TRUE,lineWeight:1.5,markersColor:#7030a0}\")"
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("B3:F5").numberFormat = "$#,##0"
worksheet.getRange("A1:G2").font.bold = true
worksheet.getRange("A1").font.size = 15.0
worksheet.getRange("A2:G5").font.size = 13.0
worksheet.getRange("A:F").autoFit()
worksheet.getRange("1:5").rowHeight = 25.0
worksheet.getRange("G1").columnWidth = 30.0
worksheet.pageSetup.orientation = PageOrientation.Landscape
// Save to a pdf file
workbook.save("LineSparkline.pdf")