SpreadJS 迷你图

= CASCADESPARKLINE(pointsRange, pointIndex, labelsRange, minimum, maximum, colorPositive, colorNegative, vertical)

// Add a cascade sparkline with horizontal bars.
for (int i = 1; i < 8; i++) {
    worksheet.getRange(i, 2).setFormula("=CASCADESPARKLINE(B2:B8, ROW() - 1, A2:A8, , , \"#8CBF64\", \"#D6604D\", FALSE)");
}

= LINESPARKLINE(data,dataOrientation,[dateAxisData],[dateAxisOrientation],[setting])

// Create a new workbook.
Workbook workbook = new Workbook();
        
// Get active sheet.
IWorksheet worksheet = workbook.getActiveSheet();
        
// Add values to the table.
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");
        
// Add line sparkline formula.
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 as a PDF document.
workbook.save("LineSparkline.pdf");
        
// Save as a .sjs file.
workbook.save("LineSparkline.sjs");

 = COLUMNSPARKLINE(data,dataOrientation,[dateAxisData],[dateAxisOrientation],[setting])

// Create a new workbook.
Workbook workbook = new Workbook();
        
// Get active sheet.
IWorksheet worksheet = workbook.getActiveSheet();
        
// Add values to the table.
worksheet.getRange("A1").setValue("Sales Data");
worksheet.getRange("A2:F6").setValue(new Object[][]
        {
                {"Salesperson", "Jan", "Feb", "Mar", "Apr", "May"},
                {"Courtney Graves", 76000, 68250, 72000, 99750, 45500},
                {"Crystal Cross", 118750, 89250, 121250, 92500, 60750},
                {"Jodi Hall", 75500, 56500, 65500, 62750, 77500},
                {"Andrew James", 76750, 108500, 88000, 55750, 106000}
        });
worksheet.getRange("G2").setValue("SparkLine");
        
// Add column sparkline formula.
worksheet.getRange("G3:G6").setFormula("=COLUMNSPARKLINE(B3:F3,1,,,\"{showMarkers: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:G6").getBorders().setLineStyle(BorderLineStyle.Thin);

worksheet.getRange("B3:F6").setNumberFormat("$#,##0");
worksheet.getRange("A1:G2").getFont().setBold(true);
worksheet.getRange("A1").getFont().setSize(15);
worksheet.getRange("A2:G6").getFont().setSize(13);

worksheet.getRange("A:F").autoFit();
worksheet.getRange("1:6").setRowHeight(25);
worksheet.getRange("G1").setColumnWidth(30);
worksheet.getPageSetup().setOrientation(PageOrientation.Landscape);
    
// Save as a PDF document.
workbook.save("ColumnSparkline.pdf");
        
// Save as a .sjs file.
workbook.save("ColumnSparkline.sjs");

 = WINLOSSSPARKLINE(data,dataOrientation,[dateAxisData],[dateAxisOrientation],[setting])

// Create a new workbook.
Workbook workbook = new Workbook();
        
// Get active sheet.
IWorksheet worksheet = workbook.getActiveSheet();
        
// Add values to the table.
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");
        
// Add win-loss sparkline formula. Use Formula2 as the formula contains a dynamic array formula (B3:F3-$I$2).
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 as a PDF document.
workbook.save("WinLossSparkline.pdf");
        
// Save as a .sjs file.
workbook.save("WinLossSparkline.sjs");