SpreadJS使用教程：如何用代码实现scale方法

SpreadJS最新试用版

Scale Rule 可以让选中区域的单元格中不同的值显示成不同的颜色，颜色随着单元格的值的大小而渐变。

示例代码

以下代码使用了 Scale 规则。

activeSheet.setValue(0,0, 1,3);activeSheet.setValue(1,0, 50,3);activeSheet.setValue(2,0, 100,3);activeSheet.conditionalFormats.add3ScaleRule(1, 10, "red", 0, 50, "blue",2, 100, "yellow", [new GC.Spread.Sheets.Range(0, 0, 10, 3)]);

示例代码

以下代码创建了两个 Scale 规则。

activeSheet.conditionalFormats.add2ScaleRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.Number,1,"Yellow",GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.Number,50,"Blue", [new GC.Spread.Sheets.Range(0,0,20,1)]);activeSheet.setValue(0,0,1,3);activeSheet.setValue(1,0,45,3);activeSheet.setValue(2,0,75,3);// ORvar rule = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();rule.ranges([new GC.Spread.Sheets.Range(0,0,20,1)]);rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.TwoScaleRule);rule.minType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.Number);rule.minValue(1);rule.minColor("Yellow");rule.maxType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.Number);rule.maxValue(50);rule.maxColor("Blue");activeSheet.conditionalFormats.addRule(rule);activeSheet.setValue(0,0,1,3);activeSheet.setValue(1,0,45,3);activeSheet.setValue(2,0,75,3);

如果你对我们的产品感兴趣或者有任何疑问，欢迎咨询在线客服>>