Worksheet::SetRange

SetRange

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples
6 Remark
7 See Also
8 header to Include

Description

Set the beginning and ending row indices for the specified columns in this Worksheet.

Syntax

BOOL SetRange( int iR1, int iR2, int iC1 = 0, int iC2 = -1 )

Parameters

iR1: [input] Input begining row index (0 based)
iR2: [input] Input ending row index (0 based)
iC1: [input] Input begining column index (0 based offset, default 0 is first column)
iC2: [input] Input ending column index (0 based offset, default -1 is last column)

Return

Returns TRUE on success and FALSE on failure.

Examples

EX1

// Usage
// Worksheet_SetRange_Ex1 1 0;// to clear worksheet
// Worksheet_SetRange_Ex1 3 200;// show rows from 3 to 200
void Worksheet_SetRange_Ex1(int nBegin, int nEnd)
{
    Worksheet wks = Project.ActiveLayer();
    // convert LabTalk index into C index
    int nR1 = nBegin - 1;
    int nR2 = nEnd - 1;
    
    if( wks.SetRange(nR1, nR2) )
        printf("Success to set range of specified column!");
    else
        printf("Fail to set range of specified column!");
}