类: Range

Spread.Sheets.Range

Table of contents

构造方法

• constructor

属性

• col
• colCount
• row
• rowCount

方法

• contains
• containsRange
• equals
• getIntersect
• intersect
• offset
• union

构造方法

constructor

• new Range(r, c, rc, cc)

区域，该区域由行索引、列索引、行数和列数组成

代码示例

var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
rule.ranges([new GC.Spread.Sheets.Range(0,0,5,1)]);
rule.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between);
rule.style(style);
rule.value1(2);
rule.value2(100);
activeSheet.conditionalFormats.addRule(rule);
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,45,3);

参数

属性名	类型	说明
r	number	行索引
c	number	列索引
rc	number	行数
cc	number	列数

属性

col

• col: number

列索引

代码示例

var cellrange = new GC.Spread.Sheets.Range();
cellrange.col = 0;
cellrange.row = 1;
cellrange.colCount = 1;
cellrange.rowCount = 8;
activeSheet.setValue(1, 0, 1);
activeSheet.setValue(2, 0, -2);
activeSheet.setValue(3, 0, -1);
activeSheet.setValue(4, 0, 6);
activeSheet.setValue(5, 0, 4);
activeSheet.setValue(6, 0, -4);
activeSheet.setValue(7, 0, 3);
activeSheet.setValue(8, 0, 8);
var setting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
setting.options.showMarkers = true;
activeSheet.setSparkline(13, 0, cellrange, GC.Spread.Sheets.Sparklines.DataOrientation.vertical, GC.Spread.Sheets.Sparklines.SparklineType.line, setting);

---

colCount

• colCount: number

列数

代码示例

var cellrange = new GC.Spread.Sheets.Range();
cellrange.col = 0;
cellrange.row = 1;
cellrange.colCount = 1;
cellrange.rowCount = 8;
activeSheet.setValue(1, 0, 1);
activeSheet.setValue(2, 0, -2);
activeSheet.setValue(3, 0, -1);
activeSheet.setValue(4, 0, 6);
activeSheet.setValue(5, 0, 4);
activeSheet.setValue(6, 0, -4);
activeSheet.setValue(7, 0, 3);
activeSheet.setValue(8, 0, 8);
var setting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
setting.options.showMarkers = true;
activeSheet.setSparkline(13, 0, cellrange, GC.Spread.Sheets.Sparklines.DataOrientation.vertical, GC.Spread.Sheets.Sparklines.SparklineType.line, setting);

---

row

• row: number

行索引

代码示例

var cellrange = new GC.Spread.Sheets.Range();
cellrange.col = 0;
cellrange.row = 1;
cellrange.colCount = 1;
cellrange.rowCount = 8;
activeSheet.setValue(1, 0, 1);
activeSheet.setValue(2, 0, -2);
activeSheet.setValue(3, 0, -1);
activeSheet.setValue(4, 0, 6);
activeSheet.setValue(5, 0, 4);
activeSheet.setValue(6, 0, -4);
activeSheet.setValue(7, 0, 3);
activeSheet.setValue(8, 0, 8);
var setting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
setting.options.showMarkers = true;
activeSheet.setSparkline(13, 0, cellrange, GC.Spread.Sheets.Sparklines.DataOrientation.vertical, GC.Spread.Sheets.Sparklines.SparklineType.line, setting);

---

rowCount

• rowCount: number

行数

代码示例

var cellrange = new GC.Spread.Sheets.Range();
cellrange.col = 0;
cellrange.row = 1;
cellrange.colCount = 1;
cellrange.rowCount = 8;
activeSheet.setValue(1, 0, 1);
activeSheet.setValue(2, 0, -2);
activeSheet.setValue(3, 0, -1);
activeSheet.setValue(4, 0, 6);
activeSheet.setValue(5, 0, 4);
activeSheet.setValue(6, 0, -4);
activeSheet.setValue(7, 0, 3);
activeSheet.setValue(8, 0, 8);
var setting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
setting.options.showMarkers = true;
activeSheet.setSparkline(13, 0, cellrange, GC.Spread.Sheets.Sparklines.DataOrientation.vertical, GC.Spread.Sheets.Sparklines.SparklineType.line, setting);

方法

contains

▸ contains(row, col, rowCount?, colCount?): boolean

获取当前区域是否包含指定的单元格

参数

属性名	类型	说明
row	number	行索引
col	number	列索引
rowCount?	number	行数
colCount?	number	列数

返回值

boolean

为true时，区域包含单元格；若为false则不包含

---

containsRange

▸ containsRange(range): boolean

获取当前区域是否包含指定区域

参数

属性名	类型	说明
range	Range	单元格区域

返回值

boolean

为true时，当前区域包含指定的单元格区域；若为false则不包含

---

equals

▸ equals(range): boolean

获取当前区域是否等于指定区域

参数

属性名	类型	说明
range	Range	要比较的区域

返回值

boolean

为true时，当前区域等于指定的区域;;若为false则不等于

---

getIntersect

▸ getIntersect(range, maxRowCount, maxColumnCount): Range

获取两个单元格区域的交集

参数

属性名	类型	说明
range	Range	单元格区域
maxRowCount	number	最大行数
maxColumnCount	number	最大列数

返回值

Range

如果没有交集或交集的单元格区域，则返回null

---

intersect

▸ intersect(row, col, rowCount, colCount): boolean

获取当前区域是否与行和列索引以及行和列计数指定的区域相交

参数

属性名	类型	说明
row	number	行索引
col	number	列索引
rowCount	number	行数
colCount	number	列数

返回值

boolean

为true时，指定区域与当前区域相交；若为false则不相交

---

offset

▸ offset(x, y): Range

按指定的坐标偏移区域的位置

参数

属性名	类型	说明
x	number	沿x轴的偏移量
y	number	沿y轴的偏移量

返回值

Range

新位置

---

union

▸ union(range): Range

将此区域与指定的区域连接为一个联合

参数

属性名	类型	说明
range	Range	目标区域

返回值

Range

返回区域的并集