• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# [a:b]

Description:

Get values from row/column/cell a to row/column/cell b to create a sequence.

Syntax:

[a:b]

Note:

The function creates a sequence by getting values from row/column/cell a to row/column/cell b.

If a and b are in the same row or column, get values from cell a to cell b to create a sequence;

If a and b are neither in the same row nor in the same column, get values from a rectangular area whose diagonal is the line connecting cell a and cell b to create a sequence.

The function can also be written as [a,b], which means getting values of cell a and cell b to creat a sequence; allow multiple parameters, like [a:b,c,d:e].

Parameter:

 a Cell name b Cell name

Return value:

A sequence

Example:

 A B C 1 1 2 3 2 a b c 3 % & * 4 =[A1:C1] [1,2,3] 5 =[A1:A3] [1,a,%] 6 =[A1:C3] [1,2,3,a,b,c,%,&,*] 7 =[A1:C1,A2,C2:C3] [1,2,3,a,c,*]