막대사탕 변동 스파크라인

=LOLLIPOPVARISPARKLINE(plannedValue,actualValue,index,absolute,reference,mini,maxi,tickunit,legend,colorPositive,colorNegative,lollipopHeaderColor,vertical);

     var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), { sheetCount: 1 });
     var sheet = spread.getActiveSheet();
     sheet.name('Lollipop variance sparkline');
     sheet.setRowCount(20);
     sheet.setColumnCount(40);
     sheet.suspendPaint();
     sheet.addSpan(0, 0, 1, 5);
     sheet.setValue(0, 0, "Regional Sales Data Analysis Statistics Table");
     sheet.getCell(0, 0).backColor("#196a99");
     sheet.setArray(1, 0, [
         ["District", "Sales target", "Actual sales", "Variance", "Variance %"],
         ["Asia", 4500, 3500],
         ["Europe", 3758, 3920],
         ["NorthAmerica", 4525, 5002],
         ["SouthAmerica", 3200, 3480],
         ["Oceania", 1540, 1800],
         ["Africa", 430, 430],
     ]);
     for (let i = 2; i < 8; i++) {
         sheet.setFormula(i, 3, '=LOLLIPOPVARISPARKLINE($B$3:$B$8,$C$3:$C$8,' + (i - 2) + ',true,,,,200,true,"#cecece","#cecece","#ffa501")');
         sheet.setFormula(i, 4, '=LOLLIPOPVARISPARKLINE($B$3:$B$8,$C$3:$C$8,' + (i - 2) + ',false,0,-0.2,0.2,0.1,true,"green","red","skyblue")');

     }
     widthList = [100, 100, 100, 300, 300];
     for (let i = 0; i < widthList.length; i++) {
         sheet.setColumnWidth(i, widthList[i]);
     }
     heightList = [50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50];
     for (let i = 0; i < heightList.length; i++) {
         sheet.setRowHeight(i, heightList[i]);
     }
     sheet.getRange('A1:E13').hAlign(1).vAlign(1);
     sheet.getRange('A1:E1').font('bold normal 15px normal');
     sheet.getRange('A1:A13').font('bold normal 15px normal');
     sheet.getRange(2, 3, 6, 1).setBorder(new GC.Spread.Sheets.LineBorder("#fff", GC.Spread.Sheets.LineStyle.empty), {
         inside: true
     });
     sheet.resumePaint();